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
|