Vlookup formula for 3 criteria

Hello,

Please could someone kindly assist.
I am battling to create a formula that uses three criteria to lookup a value.

I have attached a simple spreadsheet, that shows the layout of my current data and what the end result should be.

Any assitance would be greatly appreciated. This is taking me a while to figure out.

Many thanks.

Try:

=SUMIFS(INDEX(C8:K10,MATCH(C16,B8:B10,0),0),C6:K6,C17,C7:K7,C18)

Try this
=SuMPRODUCT((C6:K6=C17)*(C7:K7=C18)*(B8:B10=C16)*C8:K10)