summing results of autofilter

  • Thread starter Thread starter T Crosby
  • Start date Start date
T

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
 
Hi

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