how to sum contents of duplicate rows
 

Hi:
I have a worksheet with two columns and multiple rows. Column 1 has Names
and column 2 has salary.
Charles 15
John 20
John 15
Peter 50

I woul like to see (end result) something like this (note duplicate gone but
salary summed up)

Charles 15
John 35
Peter 50


Thank You Regards Charles

how to sum contents of duplicate rows
 

In C1: =A1
C2: IF(ISERROR(MATCH(0,COUNTIF(C$1:C1,$A$1:$A$20&""),0 )),"",
INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(C$1:C1,$A$1:$A$20&""),0)))

which is an array formula so commit with Ctrl-Shift-Enter, not just Enter.
Copy C2 as far as you need.

D1:=IF(C1="","",SUMIF(A:A,C1,B:B)

and copy down

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Charles" wrote in message
...
Hi:
I have a worksheet with two columns and multiple rows. Column 1 has Names
and column 2 has salary.
Charles 15
John 20
John 15
Peter 50

I woul like to see (end result) something like this (note duplicate gone
but
salary summed up)

Charles 15
John 35
Peter 50


Thank You Regards Charles