• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMIFS with INDEX MATCH

kaylaaaaa

New Member
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:
63252
 

Attachments

r2c2

Active Member
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.

 
Top