find values and add them
 

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

find values and add them
 

Hi Rick

If your data are in sheet1, then make a list of the item numbers in sheet2
column A. In column B use the SumIf formula. With your example data the
formula will look like this: =SUMIF(Sheet1!A1:A5;A1;Sheet1!B1:B5)

Regards,

Per

"RickB" skrev i en meddelelse
...
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

find values and add them
 

Quickest way is a pivot table. put your cursor in the middle of your source
data and select Data - Pivot Table... Follow the wizard. Put your part
numbers in the left column and the weights in the data area. That is all it
takes...
--
HTH...

Jim Thomlinson


"RickB" wrote:

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