alienscript
10-17-2008, 09:49 AM
Hello Excel experts,
could someone please help me how I can use sumproduct to sum the cells with conditions? my conditions are:
1) if PartNum, PO_Num and PO_Line is the same in each line, take PO_Qty only once (put in Total_Qty).
2) if PartNum, PO_Num and PO_Line is not the same in each line, take the individual line's PO_Qty (put in Total_Qty).
PartNum PO_Num PO_Line PO_Qty Total_Qty
1234-A 4201777 000010 16 16
1234-A 4201777 000010 16
1234-A 4201777 000010 16
1234-F 4201777 000010 18 18
1234-F 4201777 000020 18 18
1234-F 4201777 000030 18 18
1234-B 4201666 000010 10 10
1235-C 4201666 000010 10 10
1234-C 4201555 000010 16 16
9934-C 4201555 000020 16 16
could someone please help me how I can use sumproduct to sum the cells with conditions? my conditions are:
1) if PartNum, PO_Num and PO_Line is the same in each line, take PO_Qty only once (put in Total_Qty).
2) if PartNum, PO_Num and PO_Line is not the same in each line, take the individual line's PO_Qty (put in Total_Qty).
PartNum PO_Num PO_Line PO_Qty Total_Qty
1234-A 4201777 000010 16 16
1234-A 4201777 000010 16
1234-A 4201777 000010 16
1234-F 4201777 000010 18 18
1234-F 4201777 000020 18 18
1234-F 4201777 000030 18 18
1234-B 4201666 000010 10 10
1235-C 4201666 000010 10 10
1234-C 4201555 000010 16 16
9934-C 4201555 000020 16 16