Hero_honda

Variations of the SUMPRODUCT approach....

If you use Col_A for the lookup values (eg b2&c2&d2):
J1: =SUMPRODUCT(($A$2:$A$9=G1&H1&I1)*$E$2:$E$9)

or...if you use your table as posted:
J1: =SUMPRODUCT(($A$2:$A$9=G1)*($B$2:$B$9=H1)*($C$2:$C$9=I1)*$E$2:$E$9)

Regards,
Ron