Adding values from adjacent columns

D

DJ

Got a list of people and scores in columns A & B - everyone has multiple
lines. Need to add values for each in summary somewhere else on sheet - any
ideas of calculation for this?
 
P

Pete_UK

Suppose you have a list of unique names in column D, starting with D2.
Put this formula in E2:

=SUMIF(A:A,D2,B:B)

then copy down to get a total score for each name.

Hope this helps.

Pete
 
Top