How many quantity eache seller sold

[feejo]

I have seller numbers on one side and in the other side how many they sold. I want to know how many seller #001 sold in total, seller #002 etc...
So here seller #001 sold 1500+1000+2500+500... I thing you get it.


Seller # Q.
001 1500
001 1000
001 2500
001 500
001 1000
001 1000
001 500
001 2000
001 5000
001 2500
001 10000
001 5500
001 8500
001 1000
001 7500
001 2500
001 500
001 2000
001 6000
001 3500
001 2000
001 6500
001 2500
001 3500
001 1000
001 1000
001 2500
001 500
001 1000
001 2000
001 4000
001 7000
001 2000
001 3000
002 2000
002 1000
002 3000
002 1000
002 2500
002 1000
002 500
007 1500
007 500
007 7000
007 3000
007 1000
009 3000
009 4500
009 2000

[NBVC]

The best and quickest way would be to create a Pivot Table.

Select the table and select Data|Pivot Tables and follow the wizard instructions.

[duane]

SUMIF will also do the trick

[NBVC]

SUMIF will also do the trick

Then you will have to create the list of sellers first.