Get the unique name and the total sum of each player in different column

[dchew]

How to get the total sum of each player in different column, Example below:

Screen Shot 08-25-18 at 07.23 PM.JPG

The player name would not be fixed/constant , so how to i filter out unique player name, then add their score at the back all-together. ?

Would need this becasue player might have scored from different game then record not in-order.

[tim201110]

=sum(($a$2:$a$6=$a11)*$b$2:$e$6) cse

[FDibbins]

Another option...
=SUMPRODUCT(--($A$2:$A$6=A10)*$B$2:$E$6)

[dchew]

yes it works but i have to manually get the names, what i want is to pull the names and remove duplicates too.

[Glenn Kennedy]

List of names (in J2):
=IFERROR(INDEX($A$2:$A$10,MATCH(0,INDEX(COUNTIF($J$1:J1,$A$2:$A$11),0,0),0)),"")

Scores:
=IF(J2="","",SUMPRODUCT(($A$2:$A$10=J2)*$B$2:$F$10))

See sheet. Next time, please attach an Excel sheet, rather than a non-editable picture of one. Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.