Hi,

OK.

1.

=SUMPRODUCT(SUMIFS(INDEX($C$2:$E$7,0,MATCH(C9,C1:E 1,0)),$A$2:$A$7,INDEX(A14:B14,0,0),$B$2:$B$7,$C$14 ))

2.

=SUM(SUMIFS(INDEX($C$2:$E$7,0,MATCH(C9,C1:E1,0)),$ A$2:$A$7,{"Micl","Pirt"},$B$2:$B$7,$C$14))

3.

=SUMPRODUCT(--ISNUMBER(MATCH(A2:A7,A14:B14,0)),--(B2:B7=C14),INDEX($C$2:$E$7,0,MATCH(C9,C1:E1,0)))

HTH