I'm trying to keep track of a league's scores, but would like to keep the
frame-by-frame scores as well. I don't know how to get the correct logic to
work for the entire game (mainly because I know very little about Excel), but
have found an example that works up until the last frame. Then it only works
if you happen to get a spare or strike in the 10th frame, otherwise there's a
#NAME error. The code looks like this for the 10th frame only:
Since I know so little about Excel logic, I can't tell where the hang up is.
Any help would be greatly appreciated!