View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thom Thom is offline
external usenet poster
 
Posts: 13
Default DATA Calculation

I have a spreadsheet with a list of names in Column A and a date column in B
In the rows from C to M are various disciplines with points awarded on a
sliding scale

I need to find a way of illustrating when a person in working on a
discipline is awarded the correct points as per the sample below without me
having to manually count them each time
Can Anyone help ?

Name Date Game 1 Game 2 Game 3 Game 4 Total
Points awarded 40 38 36 34

T H 05.06.07 1 1 1 152








Thom