Sum Unique
 

Hi,
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

Sum Unique
 

On Sun, 3 Dec 2006 00:44:24 +1100, "Stephen Rainey"
wrote:

Hi,
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



You could use a Pivot Table.

Or you could use the SUMIF function.


E1: Ian F1: =SUMIF(A1:A10,E1,B1:B10)
E2: John F2: ...

etc
--ron

Sum Unique
 

1- Sort column A
2- highlight range a1:a10..etc.. conditional format with formula is ...
=A2=A1 (this is to hide the repeated names) format it with the same color
(white)
3- place in c1 this formula =IF(A2<A3,SUMIF(A$2:A$22,A2,B$2:B$22),"")
4- copy it down and then voila

I hope this helps!
================================================== ==========================


"Ron Rosenfeld" wrote in message
...
On Sun, 3 Dec 2006 00:44:24 +1100, "Stephen Rainey"

wrote:

Hi,
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



You could use a Pivot Table.

Or you could use the SUMIF function.


E1: Ian F1: =SUMIF(A1:A10,E1,B1:B10)
E2: John F2: ...

etc
--ron