SUMIFS with INDEX MATCH

[kaylaaaaa]

I have an array of data that has variables in column A and variables in rows 10 and 11 that I need to match. BUT there is not just one combination in my array thus my index match is not working. I need it to find all combinations in the array and sum the values. Is this even possible? Assistance would be a life saver.

Here is an example:

 

[r2c2]

SUMPRODUCT may be?

Like this:
=SUMPRODUCT($B$13:$J$18,((B$10:J$10=$A$3)*(B$11:J$11=$A$4))*($A$13:$A$18=A8))

See advanced sumproduct queries page for explanation of this technique.

Advanced Sumproduct Queries

Using Sumproduct to query 2D Ranges based on users criteria

chandoo.org

 

[kaylaaaaa]

This worked!!! You are my hero! Thank you!