Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum the "Bar Tabs"
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum the "Bar Tabs"
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.. "Stephen Rainey" wrote in message : 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum the "Bar Tabs"
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) "Stephen Rainey" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|