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.