I need to sum up the qty shipped of each part # for each mth
I have tryed SUMIF, SUMPRODUCT, and DSUM I can not get them to work
I would like the formula to look for the maching number in cell a2 (part #)
and add the qtys in tab "SCRAP" (c3:c9000) only if it was shipped on B1 (mth)

Can some one please help here are some that I have tried

=SUMPRODUCT((A2=CellVal1)*(B1=CellVal2)*(Scrap!D3: D9000))
=SUMIF(Scrap!$B$3:$C$9000,$A2,B1,Scrap!$C$3:$C$900 0)

thanks

Because your criteria relate to two different fields (part number and month),
sumif won't get it done for you. For sumproduct, you need each array to pull
in all the appropriate rows, so it would be something like
=SUMPRODUCT((a3:a9000=A2),(b3:b9000=b1),(Scrap!D3: D9000))
(Assuming each row 3 through 9000 has data on a single shipment, a2 has the
target part number and b1 the target shipped month.)

"Stu3500" wrote:

I need to sum up the qty shipped of each part # for each mth
I have tryed SUMIF, SUMPRODUCT, and DSUM I can not get them to work
I would like the formula to look for the maching number in cell a2 (part #)
and add the qtys in tab "SCRAP" (c3:c9000) only if it was shipped on B1 (mth)

Can some one please help here are some that I have tried

=SUMPRODUCT((A2=CellVal1)*(B1=CellVal2)*(Scrap!D3: D9000))
=SUMIF(Scrap!$B$3:$C$9000,$A2,B1,Scrap!$C$3:$C$900 0)

thanks