Home |
Search |
Today's Posts |
#1
|
|||
|
|||
subtotal instead of sum
I am using autofilter in the data menu to filter data. When I use the
autosum icon, "=Subtotal()" automatically comes up in the cell. This is fine until I change the filter, then it shows a different number until I go back to the original filter get rid of all the filters. If I manually enter "sum()" then I don't have the answer to the formula changing. I was wondering if there is a way to get it to automatically enter "sum()" when I am filtering and when I am click on the "Autosum" icon. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotal by two columns at once | Excel Discussion (Misc queries) | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Subtotal Question | Excel Worksheet Functions | |||
Subtotal And Countif | Excel Discussion (Misc queries) | |||
Subtotal question | Excel Worksheet Functions |