I think I undersatnd your problem. You want to take an Excel sheeto and turn it into a Bowling Score sheet.. that will automatically tally a score.. ie if it's an open frame it will add the total pins to the score and post the score in the frame, if they get a spare it will wait for the first ball in the next frame then add that and post it... For frames 1-9 you should be able to formulate an if statement that can be copied to ALL fames (or THREE if statements.. one for an open frame, tally now.. one for SPARE wait for nest ball, and one for Strike.. wait for next TWO balls....
If you use two rows of the excel sheet, the top row would be seperated into "first ball" and "second ball" (and "third ball" for the Tenth frame) the bottom row you can remove the liine seperating the 1st and second ball and that would be your "Frame" so you would have a box with the top seperated in two, the top two boxes would be for data entry should be no formulas there, the bottom half would be NO data entry but would contain your if statements, and your SUM... Hope this helps!! Good luck!