Hi,

1.

=SUMPRODUCT(SUMIFS($C$2:$C$7,$A$2:$A$7,INDEX(A14:B 14,0,0),$B$2:$B$7,$C$14))

2.

=SUM(SUMIFS($C$2:$C$7,$A$2:$A$7,{"Micl","Pirt"},$B $2:$B$7,$C$14))

3.

=SUMPRODUCT(--ISNUMBER(MATCH(A2:A7,A14:B14,0)),--(B2:B7=C14),C2:C7)

HTH