Summing a Field while Using an Autofilter
 

I have a large spread sheet that i must sort. I currently am using an
autofilter to sort the numbers, then copying the numbers to another sheet and
then summing those numbers. I am doing this because when using the
autofilter if you try and sum at the bottom of a column then you still sum
all the values that are hidden. Is there a way to just sum the visible
numbers when using the autofilter so that i can avoid having to copy and
paste to another sheet. This is really slowing down my program.

Summing a Field while Using an Autofilter
 

use
=Subtotal(9,B2:B50)

Subtotal only sums the visible rows from a filter.

--
Regards,
Tom Ogilvy


"Lost and Looking for Help" wrote:

I have a large spread sheet that i must sort. I currently am using an
autofilter to sort the numbers, then copying the numbers to another sheet and
then summing those numbers. I am doing this because when using the
autofilter if you try and sum at the bottom of a column then you still sum
all the values that are hidden. Is there a way to just sum the visible
numbers when using the autofilter so that i can avoid having to copy and
paste to another sheet. This is really slowing down my program.