Columns Counting Function Reqd
 

Hello Fellow Excel users,

I have alittle problem which i hope somebody can point me in the right
direction

Picture my screen in excel

Col A is a list of Names with Multiple entries for the same person

Col B is a number ranging from 0 to 7

eg

A B

Joe Bloggs 1
Jim Smith 2
Joe Bloggs 4
Pete Smith 5
Jim Smith 4


What i want to create is another list where

Col A is a list of names Just 1 entry per name
Col B the sum of all entries for that persons name


eg

A B

Joe Bloggs 5
Jim Smith 6
Pete Smith 5


I hope ive explained it ok

if you have any questions just email me




Cheers


Steve

Columns Counting Function Reqd
 

It seems like a pivot table would be well suited to your situation:

First, make sure you have column headings (example: Name, Amount) in Cells
A1 and B1

<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW: Drag the Name field here
DATA: Drag the Amount field here
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each Name and the Sum of Amount.

To refresh the Pivot Table, just right click it and select Refresh Data

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Debby Bunce" wrote:

Hello Fellow Excel users,

I have alittle problem which i hope somebody can point me in the right
direction

Picture my screen in excel

Col A is a list of Names with Multiple entries for the same person

Col B is a number ranging from 0 to 7

eg

A B

Joe Bloggs 1
Jim Smith 2
Joe Bloggs 4
Pete Smith 5
Jim Smith 4


What i want to create is another list where

Col A is a list of names Just 1 entry per name
Col B the sum of all entries for that persons name


eg

A B

Joe Bloggs 5
Jim Smith 6
Pete Smith 5


I hope ive explained it ok

if you have any questions just email me




Cheers


Steve

Columns Counting Function Reqd
 

spot thansk mate you have made a chap very happy

i simplfied my problem as column a and b have up to 60000 lines of data

im the results secretary of darts and dominoes league in grimsby egland and
this has help very substancially

thanks alot again


cheers


steve



"Ron Coderre" wrote in message
...
It seems like a pivot table would be well suited to your situation:

First, make sure you have column headings (example: Name, Amount) in Cells
A1 and B1

<Data<Pivot Table
Use: Excel
Select your data
Click the [Layout] button

ROW: Drag the Name field here
DATA: Drag the Amount field here
Click [OK]
Select where you want the Pivot Table...and you're done!

That will list each Name and the Sum of Amount.

To refresh the Pivot Table, just right click it and select Refresh Data

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Debby Bunce" wrote:

Hello Fellow Excel users,

I have alittle problem which i hope somebody can point me in the right
direction

Picture my screen in excel

Col A is a list of Names with Multiple entries for the same person

Col B is a number ranging from 0 to 7

eg

A B

Joe Bloggs 1
Jim Smith 2
Joe Bloggs 4
Pete Smith 5
Jim Smith 4


What i want to create is another list where

Col A is a list of names Just 1 entry per name
Col B the sum of all entries for that persons name


eg

A B

Joe Bloggs 5
Jim Smith 6
Pete Smith 5


I hope ive explained it ok

if you have any questions just email me




Cheers


Steve