Excel Columns Problem

[Debby Bunce]

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

 

[Franz Verga]

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

 

[Epinn]

Hi,

Hope the following link helps.

Five ways to subtotal values in repeating data

http://office.microsoft.com/en-us/assistance/HA011366211033.aspx

Cheers,

Epinn

 

[Debby Bunce]

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

thanks again


steve

 

[Debby Bunce]

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


thanks again


steve

 

[Epinn]

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/assistance/HA011989031033.aspx
Epinn