INDEX MATCH summing values found

[hannahmc8]

I have entered an INDEX MATCH array to find a cell dependent on 2 criteria:

=INDEX($D$23:$D$26,MATCH(E24,IF($C$23:$C$26=F24,$B$23:$B$26),0))

It works which is great but there are two values which match the criteria. How can I sum the values if two or more are found?
I

 

[GlennUK]

What version of Excel do you have? If 2007, or later, then look at the SUMIFS worksheet function. Otherwise a SUMPRODUCT like:
=SUMPRODUCT(($D$23:$D$26)*--(E24=$B$23:$B$26)*--($C$23:$C$26=F24))

 

[hannahmc8]

Thank you Glen!

 

[GlennUK]

My pleasure!