Sumif including index,match formulas

Hi All,

I'm trying to do a SUMIF formula, but the way the data is set up I need to use the index and match function to look at multiple data points.

In Sheet1, I have store numbers in Column A, and Product Codes in Row 4. In Cell A1 is a date, which will change each week.

In sheet 2, I have a data range A1:AT31. Column A has the store number. Column B has the product code. in row 1 are the dates.

Based on the store number, product, and date, I am trying to populate data into Sheet1. I have this formula so far:

=SUMIF(Sheet2$A$2:$A$31,Sheet1$A$5,INDEX(Sheet2$B$2:$AT$31,0,MATCH(Sheet1$A$1,Sheet2$A$1:$AT$1,0)))

So I'm nearly there but can't figure out how to add the product criteria into the formula. I've attached a sample spreadsheet to help.

Any help would be appreciated.

CheersSample_2205.xlsx

use below formula hope this will help..
=SUMIF(Sheet2!$A$2:$A$31,Sheet1!$A5,INDEX(Sheet2!$C$2:$AT$31,,MATCH($A$1,Sheet2!$C$1:$AT$1,0)))

here with sumproduct