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

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


Hi Steve,

first of all select your A column then from menu Data, Filter, Advanced
Filter, you can create a new list of unic entries in another location of
your sheet, then using the SUMIF function beside this new list of names you
can sum the values in your original list.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

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

thanks for the reply but ive created a pivot table and im sorted now

thanks again


steve


"Franz Verga" wrote in message
...
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


Hi Steve,

first of all select your A column then from menu Data, Filter, Advanced
Filter, you can create a new list of unic entries in another location of
your sheet, then using the SUMIF function beside this new list of names
you can sum the values in your original list.


--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

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

Steve,

Thank you for your feedback. I like PivotTable too. It is so dynamic.

In case you are interested ......
http://office.microsoft.com/en-us/as...989031033.aspx
Epinn



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