Sum only filtered selection
 

I am dealing with almost 4,000 rows of data. I am auto filtering them and I
would like to be able to sum up only the filtered selection. I can do it
manually each time it is filtered, but I was wondering if there was a way to
do this automatically.

Subtotals doesn't work for you?
http://www.officearticles.com/excel/...soft_excel.htm

*******************
~Anne Troy

www.OfficeArticles.com


"pkunAAC" wrote in message
...
I am dealing with almost 4,000 rows of data. I am auto filtering them and
I
would like to be able to sum up only the filtered selection. I can do it
manually each time it is filtered, but I was wondering if there was a way
to
do this automatically.

Good afternoon kpunAAC

Try this:

=SUBTOTAL(9,A1:A4000)

HTH

DominicB


--
dominicb
------------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932
View this thread: http://www.excelforum.com/showthread...hreadid=386785

You may also want to take a look at the DSUM function. It would allow instant
updating by changing criteria without having to AutoFilter the data at all.

HTH |:)

"pkunAAC" wrote:

I am dealing with almost 4,000 rows of data. I am auto filtering them and I
would like to be able to sum up only the filtered selection. I can do it
manually each time it is filtered, but I was wondering if there was a way to
do this automatically.