Can autofilter sum and average columns of numbers? Thank you
 

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.

Can autofilter sum and average columns of numbers? Thank you
 

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!

In article ,
Bryan W <Bryan wrote:

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.

Can autofilter sum and average columns of numbers? Thank you
 

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

On Mon, 18 Sep 2006 12:11:02 -0700, Bryan W <Bryan
wrote:

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.