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
--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile:
http://www.excelforum.com/member.php...o&userid=21419
View this thread:
http://www.excelforum.com/showthread...hreadid=544797