I can't work out your references but if you potentially have more than
one quantity for a specific part number and ship date you probably need
a different formula e.g.

=SUMPRODUCT(--(F2:F5=X1),--(G2:G5=Y1),H2:H5)

where F2:F5 contain your part numbers and X1 the specific part you wish
to sum for and G2:G5 contains your dates and Y1 your specific date,
H2:H5 contains your quantities


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=509520