Combining Match and SUMIF
Hopefully this is something that has been done before, although I couldn't find it in searching this morning.
I need to do a SUMIF on a selection of data where the range is in column J, and the sum range is columns K through BB depending on another criteria (month) which is held in another cell. What I want to do is embed a MATCH statement into a SUMIF, or use some other formula that achieves the same result.
Here's how it looks as a formula:
Any suggestions? Hopefully the description and the formula show what I am trying to achieve.
Video Tutorials / Excel Dashboards Reports