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)