Combine rows by adding amounts found in column d for duplicate names in Column a

SampleDuplicates.xlsx

I need to combine the rows that have the same names ex: Travis Taylor $8.51

The numbers will be used in a vlookup on another accounting page. I also need to do the same thing with the accounting page but there are many more columns of data.

Thanks for the help!

Hi bnasty,

Couple of things to do first:
1. convert D2:D15 to numbers (currently text with a hard return?!?)... quick way, highlight D2:D15, goto Data, Data Tools, Text to Columns, Delimited, Next, check Space and check Other: $, next, Do not import column (skip) for the first column, next, finish.
2. get unique values of the names... quick way, copy column C to column F, then Data, Remove Duplicates

After those 2, then in cell G2, you can use this formula... =SUMIF($C$2:$C$15,F2,$D$2:$D$15)

Let me know if this doesn't work.

Later,
Dennis

SampleDuplicates2.xlsx

Followed the steps, this is as far as I got.

I was having the same problem of returning 0's when I tried. I thought it might be the text/hard return thing but I guess not. The reason the cells are formatted like that is because they're parsed from emails using a macros that works with outlook.

What do you think?

Hi bnasty,

You were close, but you "removed the duplicates" on the wrong column... if you want Column F as is, then change the formula to this...

=SUMIF($B$2:$B$19,F2,$D$2:$D$19)

Look up the logic on how SUMIF works...