Is this what you want:
=SUMPRODUCT(--(Sheet1!F2:F1900='1340 -
001'!B8),--(Sheet1!D2:D1900='1340 - 001'!C8),--(Sheet1!C2:C1900='1340 -
001'!F8),--(Sheet1!G2:G1900='1340 - 001'!G6),Sheet1!J2:J1900)
--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile:
http://www.excelforum.com/member.php...fo&userid=7094
View this thread:
http://www.excelforum.com/showthread...hreadid=469906