Can autofilter sum and average columns of numbers? Thank you

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You can use the SUBTOTAL function...

To sum:

=SUBTOTAL(9,Range)

To average:

=SUBTOTAL(1,Range)

See the help menu for other allowable functions...

Hope this helps!
 
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
 
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
 
Back
Top