Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting up a validation of data listbox to provide the unique items within a range | Excel Worksheet Functions | |||
existing unique value formula help (index(match(countif))) | Excel Worksheet Functions | |||
how do i find unique avg buy prices in multiple group of buys/sell | Excel Worksheet Functions | |||
code not unique find latest date | Excel Discussion (Misc queries) | |||
count unique with conditions | Excel Worksheet Functions |