Adding values from adjacent columns
 

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?
--
DJ

Adding values from adjacent columns
 

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

On Nov 18, 11:07*am, DJ wrote:
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?
--
DJ

Adding values from adjacent columns
 

Pivot table ?
HTH
Daniel

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?