![]() |
#2
|
|||
|
|||
![]()
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 |
Tags |
autofilter, autosum |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
coxjamd | Excel Programming | 2 | 01-17-2013 02:24 PM |