Sum Button Doing wrong Function

  • Thread starter Thread starter bproberts
  • Start date Start date
B

bproberts

Somehow, my Sum botton, in the toolbar, is doing a subtotal function instead
of a simple Sum. how can I change this back to the original function?
 
If your data is filtered, then excel is smart enough to use =subtotal().

Actually, xl2003 looks to be even smarter--I had to have filters applied and I
had to have filtered my data.

Any chance that's what you're doing?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional SUBTOTAL in XL210 Table 7
Sum function limits 1
Multiple formulas in subtotal 2
Can i hide parts of a Pivot tables subtotals??? 2
Getting Text data using the Data - Subtotal feature 1
Subtotal/Consolidate/Pivot Table, Lookup ??? 2
Totaling Subtotals 2
How to copy the function SUM but offseted in 7 columns 2

Back
Top