I have looked at past postings and found a couple of them and the formula's
did not work. Here is what I want to do:

In column A I have part numbers and column B I have the weights of each time
we ordered them (weights varied due to volume ordered) I want to make a
formula that will search Column A for a part number and go to Column B and
record that weight. This spreadsheet has about 20 different part numbers and
we have ordered them constantly over the last 3 years. I need to add up the
total weights from column B for each part number to see which part numbers
have been ordered the most.


A B

EX1234 1000
EX1235 950
EX1236 1250
EX1234 1500
EX1235 1200

For example I would like the formula to return 2500 LBS for item EX1234.
The speadsheet I have over 3 years has thousands of numbers in column A and
they are basically about 15 to 20 different numbers.

Thanks,

Rick