Excell will not add multiple sums together, what do I have turned.

K

Kenny's Key West

I am trying to use the auto sum feature, when I try to add multiple auto sums
together,, it returns a zero total. what do I need to turn on or off to so I
can get the correct total
 
D

Dave Peterson

I'm guessing that the autosum was applied to a range that had
data|filter|autofilter applied (and the data was filtered).

The autosum figured that you wanted to use a =subtotal() function.

(If the data did not have an active filter, then the autosum button will guess
=sum().)

Anyway, =subtotal() is a pretty smart function. It knows to ignore other
=subtotals().

So you can either change the formula to use =sum() or use =subtotal() against
the original range of data cells.
 
Top