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