Excel SumProduct Formula Filter by Month or Year Question
Hello,
The attached sample file has a monthly filter which works fine. I'd like to know if there is a way to add a yearly filter so if someone wants to see the entire year of 2013, they can add just the year to pull all of the results?
Thanks!
EE-Sample.xlsx
The attached sample file has a monthly filter which works fine. I'd like to know if there is a way to add a yearly filter so if someone wants to see the entire year of 2013, they can add just the year to pull all of the results?
Thanks!
EE-Sample.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect! Thanks!
EE-Sample.xlsx