Sum only filtered selection

[Guest]

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.

 

[Anne Troy]

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

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

www.OfficeArticles.com

 

[dominicb]

Good afternoon kpunAAC

Try this:

=SUBTOTAL(9,A1:A4000)

HTH

DominicB

 

[Guest]

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 |:>)