Index Match formula for Google Sheets

[jimbogarner]

Hi,

I'm trying to use an index match formula that looks up multiple criteria in a grid, however, the issue I have is that there will be multiple lines that meet the same criteria and I want it to sum them all up? So for example I have the following table in a tab called TM1 Data Dump

I have the below formula in a different sheet;
=-INDEX(TM1_Data_Dump!$F$13:$P$2298,MATCH(1,(TM1_Data_Dump!$A$13:$A$2298=$D4)*(TM1_Data_Dump!$B$13:$B$2298=$B$6)*(TM1_Data_Dump!$D$13:$D$2298=$C6),0),MATCH(1,(TM1_Data_Dump!$F$11:$P$11=D$2)*(TM1_Data_Dump!$F$12:$P$12=D$3)))

The issue is, I need it to look up the quarter but as the data is retrieved by month it doesn't sum the 3 entries per quarter up... the other issue is, this is per our financial year, so Q1=Jul-Sep...

Edit - forgot to add the snip from the second tab the formula is in;

Thanks,

James

 

[Fluff]

Glad we could help & thanks for the feedback.