Can autofilter sum and average columns of numbers? Thank you

[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.

 

[Domenic]

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!

 

[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

 

[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