First post, let's get to it!
I use a formula like this in my sheet -
=(SUMPRODUCT(--(TEXT(Sales[Date],"mmmm")=E$2),Sales[Total]))
This grabs a number if the value matches my columns month.
My problem is last years data is being added in again for last october, so I need a way to make it check for month and year.
I have many sheets, each for a different stage of business. Lets say I sold a product, I store that sale as 10/25/2016. Then, I have a summary sheet, which uses the sumproduct to retrieve this data later.
How can I change the formula up top to reflect this? I could add the current year somewhere in an open cell.
Open to ideas if there's an easier way using a totally different formula too! Thanks!
Open in new window
and make sure E$2 returns something like: October 16 instead.