Excel Totalling

I want to add up the quanities and consolodate all the fields into 1 field.

for example below has item numbers on the left and i want to to make each item number 1 line but to add up the quantities on the right hand side?

 

2607336169 18V 1.3Ah Li-Ion Battery   -1
2607336169 18V 1.3Ah Li-Ion Battery   1
2607336169 18V 1.3Ah Li-Ion Battery   -1
2607336169 18V 1.3Ah Li-Ion Battery Bosch 18V Li-ion Compact Battery Pack 1.3Ah 260733 -1
DE9095 18V 2.0AH BATT   -4
DE9095 18V 2.0AH BATT   -1
DE9095 18V 2.0AH BATT   1
2607335687 18V 2.6Ah NiMh Battery   -2
PAN-EY9251B31 18v 3.3Ah Ni-Mh   -1
PAN-EY9251B31 18v 3.3Ah Ni-Mh   -1
PAN-EY9251B31 18v 3.3Ah Ni-Mh   -1

By: Oscar Neill

Leave a Reply

Your email address will not be published. Required fields are marked *