EXCEL - Sumproduct using AND statement?
Posted on 2016-10-25
First post, let's get to it!
I use a formula like this in my sheet -
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!