match formula to find total score of a person appearing more than once in list

Hi! All,

I have a list of people in column A and their scores in column B. The name of one person appears more than once and also their scores appear more than once. I want a formula to get the total score of an individual.

in a different column you would place the list of individuals and then in the next column the formula =sumif(the cell to be totaled ,A:A, B:B) if you want the average
then =sumif(...)/countif(cell,a:a)

300113.xlssorry! but it doesn't work...i am attaching a dummy file for your reference

my apologies, it should be =sumif(A:A,e1,b:b) and the same for =countif(a:a,e1)

Col A names, col B values,
C2 =IF(COUNTIF($A$2:$A2,$A2)=1,ROW(),"") copy down to match col A
E2 =IF(ROWS($1:1)>COUNT(C:C),"",INDEX(A:A,MATCH(SMALL(C:C,ROWS($1:1)),C:C,0)))
F2 =IFERROR(SUMIF(A:A,E2,B:B),)
Copy E2:F2 down until col E displays blanks.

all sorted...thanks rcm, you are great!