auto sum function

[Roger R]

I had someone send me an excel file that is acting strange.
When I click the sigma (auto sum) button, which normally
would produce the =sum() function, it produces a =subtotals
(9). Why is it putting this function in and why does it
put the "9" in front of everything? By the way it's not
summing up what I need it to sum up.

 

[Peo Sjoblom]

=SUBTOTAL(9,Range) sum visible cells that are filtered either through
autofilter, advanced filter or subtotal.
I assume you are using any of the above mentioned.. If you want to sum the
whole range and include
hidden cells you need to enter it manually. Of course if there are no hidden
cells both formulas return the same
result

 

[Guest]

I am using an advance filter, and I have attempted to
manually enter the =sum() formula, which didn't work
either.