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
|