summing results of autofilter

[T Crosby]

I have a file containing an account receivable aging report. After running
the autofilter, I would like to be able to view the sum of the output (i.e.
sum of A/R outstanding 1-30 days, 31-60 days, etc...).

How do I sum up a range without adding in the hidden rows?

Thanks.

Todd

 

[Andy B]

Hi

Have a look at the SUBTOTAL function. This doesn't calculate the lines
hidden by AutoFilter.

 

[Leo Heuser]

Todd

Have a look at the SUBTOTAL() function.