how to sum up qty totals for non-duplicate values ?

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Hi,

Do you know in EXCEL how can I sum up the total Order Qty base on only
the "unique" PartNumber ?

Any help is very much appreciated. Thank you.

Any help is very much appreciated. Thank you.

PartNumber unique/duplicate PN? Order Qty Total Order Qty
7050905500 unique 2 10
7050905500 duplicata 3
7050905500 duplicate 5
7051605400 unique 1 1
0010-01419 unique 4 8
0010-01419 duplicate 4
 
Column A is nicely sorted???
If yes:

=IF(A2=A1,"",SUMPRODUCT(($A$2:$A$99=A2)*($C$2:$C$99)))

(adjust your range accordingly)
 
And that formula should go into D2.

Dave said:
Column A is nicely sorted???
If yes:

=IF(A2=A1,"",SUMPRODUCT(($A$2:$A$99=A2)*($C$2:$C$99)))

(adjust your range accordingly)
Click to expand...
 
Back
Top