Morrigan, thanks for your help, that's exactly what I wanted. Appreciate it.

Smock

"Morrigan" wrote:


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