Index Match that can sum multiple columns of data that match multiple column/row criteria

[ComstockExcel]

Hi all,

I'm building out some financial reporting and I could use some help. I'd like to be able to sum certain data points within a table where multiple criteria for the X and Y axis are met. The table below is an example of what I'm looking to solve. My gut tells me this can be done with an index/match function that has some sort of other qualifier or sum formula to it.

In the example below, the green is my data table, and the black are my row and column variables. I'd like to build a formula that If I enter in my 2 row variables and one column variable, that it would sum any of the data points where those align in the table. In the example below, I'm looking to sum anything that has the rows with both YTD and 2019 in them that intercept with the the column that has Product 3 in it (It should spit out the sum of the 3 orange highlighted values).

Thank you for any help you can offer. If this formula is possible it would literally save me hours each month in financial reporting.

~Ryan

 

[Marcelo Branco]

Welcome to MrExcel forum

Try
=SUMIFS(INDEX($J$7:$T$13,MATCH(L18,$I$7:$I$13,0),0),$J$2:$T$2,L16,$J$5:$T$5,L17)

M.

 

[ComstockExcel]

@Marcelo Branco , you are the BEST! Thank you so much! This is going to save me so much time.

 

[Marcelo Branco]

You"re welcome. Glad for help.

M.