How do I add the values of duplicates together in a separate column?

**banestyrelsen** · 03-30-2008, 01:08 PM

I would be very grateful if somebody could help me out with this.

Column A has a list of items where some items occur more than once, and column B has a value for each item.

I want column C to show the same information as column B, except add the values for the duplicates in column A together, like so:

A. B. C
a 10 25
b 10 10
a 15 25
c 10 10
d 10 10

**oldchippy** · 03-30-2008, 01:30 PM

Hi,

Try this in C1 and copy down

=SUMPRODUCT(--($A$1:$A$100=A1)*(--(B$1:$B$100)))

**banestyrelsen** · 03-30-2008, 03:24 PM

Works like a charm! Thank you!

**broro183** · 03-31-2008, 03:19 AM

hi,

An alternative is to copy the below down in column C as needed:
=SUMIF($A$1:$A$100,$A1,$B1:$B$100)

OldChippy, I was just just wandering through the day's posts & when I spotted this one I became curious... is there an advantage to using Sumproduct over Sumif in this case?

Rob