Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSum on a filtered sheet
Something I just noticed....
Using Excel 2002 When an autofilter is applied and rows are filtered and you then use AutoSum, Excel uses the SUBTOTAL function instead of SUM *even* if the AutoSummed range is outside of the filtered range. Try this out: Put some random data in A1:A10 Apply the autofilter and filter the range on something. Enter some random numbers in J15:J20. Select J15:J21 then click on AutoSum. Biff |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSum on a filtered sheet
It also does the same thing on XL2007. It uses the SUBTOTAL function instead
of SUM. "T. Valko" wrote: Something I just noticed.... Using Excel 2002 When an autofilter is applied and rows are filtered and you then use AutoSum, Excel uses the SUBTOTAL function instead of SUM *even* if the AutoSummed range is outside of the filtered range. Try this out: Put some random data in A1:A10 Apply the autofilter and filter the range on something. Enter some random numbers in J15:J20. Select J15:J21 then click on AutoSum. Biff |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
AutoSum on a filtered sheet
I'm using xl2003.
After I apply the filter arrows and filter the data, then select J21 and click on the dropdown arrow and choose Sum, it uses =subtotal(). But if I go through the "more functions" and choose sum, it uses =sum(). In xl2003, if I use data|list on the A1:A10 and filter it, then the autosum button uses =sum(). "T. Valko" wrote: Something I just noticed.... Using Excel 2002 When an autofilter is applied and rows are filtered and you then use AutoSum, Excel uses the SUBTOTAL function instead of SUM *even* if the AutoSummed range is outside of the filtered range. Try this out: Put some random data in A1:A10 Apply the autofilter and filter the range on something. Enter some random numbers in J15:J20. Select J15:J21 then click on AutoSum. Biff -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO TURN ON 'AUTOSUM' ON ON A PROTECTED SHEET THRO VB | Excel Discussion (Misc queries) | |||
Autosum returns 0 value on data sheet | Excel Worksheet Functions | |||
Updated filtered data on next sheet | Excel Discussion (Misc queries) | |||
If protecting a sheet I lose the autosum feature, any way around | Excel Discussion (Misc queries) | |||
Help needed! - How do I save a filtered sheet? | Excel Discussion (Misc queries) |