G
Guest
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!D39000))
=SUMIF(Scrap!$B$3:$C$9000,$A2,B1,Scrap!$C$3:$C$9000)
thanks
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!D39000))
=SUMIF(Scrap!$B$3:$C$9000,$A2,B1,Scrap!$C$3:$C$9000)
thanks