View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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