I'd bet it doesn't, not with unequal ranges. #N/A is more likely.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John Michl" wrote in message
oups.com...
This works for me...
=SUMPRODUCT((B2:B1589="ICM")*(C2:C1589="YES")*(D3: D6))

- John
www.JohnMichl.com