Adding cell values in one column based on the values in another column

[excelnow]

I have two columns in my Excel sheet. Column A stores names, column B stores numbers related to those names. Think about it as a score log for the people in column A.

Name | Points
John 5
Adam 3
David 12
John 4
Mark 4
Adam 6
Adam 2

What I want to achieve is to add all the scores of each person as follows (possibly by outputting the result on columns C and D):

Name | Total Points
John 9
Adam 11
David 12
Mark 4

Is this possible?

Thanks for any ideas.

 

[pplstuff]

Use sumif(). Assuming your data is in colA and colB:

C2: =sumif(A:A,"="a1,B:B) <-drop down.. If you have a list of all names you can do it a bit differently. Look up "excel magic tricks" on youtube, around magic trick #916 or 917 they show you how to make dynamic lists, so you could pull all distinct names. Hope this helps.

 

[excelnow]

Thanks for the tip. Here is what I did:

I have names in A, numbers in B, unique names (removed duplicates) in C, and in column D I have this function "=SUMIF(A:A;C:C;B:B )" and it worked as I wanted.