Adding values from adjacent columns

  • Thread starter Thread starter DJ
  • Start date Start date
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?
 
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
 
Back
Top