Sum the "Bar Tabs"

[Stephen Rainey]

Hi All,
I want to identify unique customer names from column A, AND, sum the
respective amounts from Column B, to produce a result similar to that below.

Any suggestions please ?

A B
John 50.00
Peter 11.00
Paul 20.00
Ian 10.00
John 15.00
Ian 20.00
Paul 13.50

RESULT=> Ian 30.00
John 65.00
Peter 11.00
Paul 33.50

Regards Steve

 

[JMay]

You want the Sumif() function - Click of the fx button above Column B
And Select All - then look for Sumif() then the help button.
It will solve your problem..

 

[Guest]

Assuming your headers in A1:B1
and your data in row A2:B7
Go to Data > Filter > Advanced Filter > Select Copy to another location
List range: A2:B7
Copy to: select any emty cell example D1
click on Unique records only and click OK (you will have all the unique
record)

In E2 =SUMIF($A$2:A7,D2,$B$2:$B$7)