The sheet called "Logscores" is exactly what i want, however. I want to create some formulas based on the values in here yet if i start new game it will no longer work and the formulas disappear.
Essentially what i want is to have the scores in running so something like this:
If games = 1, then my formula will return the values in those two colums: CumPoints-A & CumPoints-B.
This would continue as the game continues, so i would have a list of Game 1, Game 2 etc etc and the points scored in each. I would like these formulas not to need changed so when i do clear results and start a new game they remain.
Any ideas?
Cheers.
Bookmarks