thanks for the reply and im using a pivot table and im all sorted now


thanks again


steve



"Epinn" wrote in message
...
Hi,

Hope the following link helps.

Five ways to subtotal values in repeating data

http://office.microsoft.com/en-us/as...366211033.aspx

Cheers,

Epinn

"Debby Bunce" wrote in message
...
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