SUMIFS INDEX MATCH MATCH

[BJH1995]

Hello,

I was wondering if anyone could assist with a formula. I currently have a Index Match Match formula which is working for me:

=INDEX($B$16:$K$17,MATCH(D4,A16:A17,0),MATCH(C4,$B$15:$K$15,0))

However i would like to incorporate a SUMIFS within this to pick up multiple values which meet the criteria. Eg. atm the above formula returns 100,000 whereas i would like it to return 150,000

Any help would be hugely appreciated.

I have attached an image of my data.

Thanks,

 

[Fluff]

How about
=SUMPRODUCT((A16:A17=D4)*(B15:K15=C4)*(B16:K17))

 

[BJH1995]

Thanks Fluff as always. works perfect

 

[Fluff]

You're welcome & thanks for the feedback.