Hi folks
I am trying to create a spreadsheet for a race. There will be around 10 – 20 entrants.
There are points to be gained for each segment of the race, but points will vary.
What I need to do is to create scorecards for each participant. I would like a race official to be able to add an x for example each time a participant wins a segment. The idea is that this x would result in another cell in the spreadsheet being filled in with the points for that segment.
So the logic is
i) Does the participant qualify for points?
ii) If no, do nothing and the points row will be zero.
iii) If yes, the official adds an x to that segment, and next to it the spreadsheet looks up the points for that row, and adds the points value.
At the end I should therefore end up with a long row of points and some zeros, and know who has got what total amount of points.
I am not too sure what function will do this. If someone could point me in the right direction that would be extremely helpful as my use of Apple help is not really telling me what I should be looking for.
Many thanks!
Simon