Dier Eluom
asked on
Adding scores on page
In an excel sheet I want to have scores added up by contestant - say in B1 is the persons name 'Billy Brown' and in C1 is 10. So the formula has to cycle through the B and C column then add only the scores for that persons name. It would be good if it could put the persons name in say D1:D5 and their total scores next to their names in E1:E5
ASKER
What about where you have the same person entered twice - i.e. they won two events?
Please upload a sample workbook with some dummy data and mock up your desired output manually for some cells. That will help to visualize your question.
ASKER
Its exactly as your workbook example is set up. Imagine though that 'Billy Brown' appears twice in the D column and two scores for Billy in the E column.
What do you want in that case then? List both the scores in C1 or sum of the scores for Billy in C1?
ASKER
Sum of scores thanks!
Then try...
=SUMIF($D$1:$D$5,B1,$E$1:$E$5)
ASKER
Sorry but that doesn't work. The first did but ignored where a name and score was in the list twice. Its getting it to add those scores under the same name
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you. Works a treat!
You're welcome Dier!
In C1
Open in new window