Can autofilter sum and average columns of numbers? Thank you

B

Bryan W

When using autofilter is it possible to sum or average columns of numbers?
When I filter a data base the column return includes all the filtered out
numbers. If not is there an add on I can use? Thank you for any help you
can provide.
 
G

Gord Dibben

Look at the SUBTOTAL Function in Help

i.e. =SUBTOTAL(9,A1:A56000) will Sum the filtered items in column A


Gord Dibben MS Excel MVP
 
Top