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 |
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 |
All times are GMT +1. The time now is 08:09 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com