Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excell will not add multiple sums together, what do I have turned.
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 |
#2
|
|||
|
|||
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. Kenny's Key West wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XML / parent with multiple children and with multiple children | Excel Discussion (Misc queries) | |||
Sum with multiple conditions in Excel 2000 | Excel Worksheet Functions | |||
multiple entries | Excel Worksheet Functions | |||
Why can't we see or access MS Excell 2003 even though we have MS . | Setting up and Configuration of Excel | |||
EXCELL 2002 Glitch???? | Excel Discussion (Misc queries) |