Hi Grasshopper



Use the SUBTOTAL function. I personally would insert a row above your data and put column headers ie: Month & Sales. So your filters will be in these cells.

Then in B1: =SUBTOTAL(109,$B$3:$B$103)

Edit: Forgot to add that you could also use a Pivot Table. See the attached file.

Kevin

Attached Files

002-Sum on AutoFilter.xls (36.5 KB, 15 views)

Kevin,
Thanks so much! SUBTOTAL is exactly what I need. I'm so mad at myself for not figuring it out on my own, but I guess that's what this forum is for anyway. Thanks again!

Lynn (aka grasshopper)

Hi Lynn

No problem and thanks for the feed back.

Kevin