How to add values?

  • Thread starter Thread starter 13
  • Start date Start date
1

13

I have a long list in excel where the Number can occur in several different
positions with diffrent Value.
I want the Number to only occur once and the Value of the different
positions added.

Like this:

Number Description Value
123-abc Dog 5
123-abc Dog 3
321-abc Cat 4

And I want Excel to add the

Number Description Value
123-abc Dog 8
321-abc Cat 4

Any help appreciated!
 
If you simply want to get the summation, then use the sumif command.
suppose your number column starts from A1 then if you want to sum collumns
for "DOG", it will be as follows:
SUMIF(B2:B3;"DOG";C2:C3)
If you want to get a unique list of columns, then use
Tools/Filter/Advanced filter/ get unique list.

HTH
 
Back
Top