T
T. Valko
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
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