How to Track Your Games with Bowling Score Calculator in Excel

The beauty with Excel is you can create basically anything with it. I love bowling and figured, why not create a bowling scoring sheet in Excel?

Key Takeaways:

• Strikes and spares pull from future score, so your formulas must look ahead to properly apply bonuses for each frame.
• The 10th frame breaks the normal rules—it may include 3 rolls, and there are no chained bonuses. It requires a different formula setup.
• Use data validation, absolute references, and template protection to avoid entry errors and broken formulas in your calculator.

Setting Up Your Bowling Score Calculator

Layout Structure

Here’s how to get started:

• Row 3 = Input rolls (like X, /, -, or numbers)
• Row 4 = Frame scores (C4, E4, G4…)
• Row 5 = Helper row to convert symbols to numbers

Convert Symbols to Numbers (Row 5)

Here’s how I turned symbols into scores:

Frame 1 Roll 1 (C5):

=IF(C3=”X”, 10, IF(C3=”-“, 0, VALUE(C3)))

Frame 1 Roll 2 (D5):

=IF(D3=”/”, 10 – C5, IF(D3=”-“, 0, VALUE(D3)))

I copied that logic across the row (E5, G5, etc.), adjusting for frame pairs.

Frame Score Calculations (Row 4)

Now we handle the strike, spare, and open frame logic here.

Frame 1:

=IF(C3=”X”, 10 + E5 + IF(F3=”/”, 10 – E5, F5), IF(D3=”/”, 10 + E5, C5 + D5))

• Strike = 10 + next two rolls
• Spare = 10 + next roll
• Open = R1 + R2

I replicated this for all frames up to Frame 9.

Handle Frame 10

Frame 10 is different—it can have 3 rolls.

U5 (F10R1):

=IF(U3=”X”, 10, IF(U3=”-“, 0, VALUE(U3)))

V5 (F10R2):

=IF(V3=”/”, 10 – U5, IF(V3=”X”, 10, IF(V3=”-“, 0, VALUE(V3))))

W5 (F10R3):

=IF(W3=”X”, 10, IF(W3=”-“, 0, VALUE(W3)))

U4 (Frame 10 Score):

=IF(U3=”X”, 10 + V5 + W5, IF(V3=”/”, 10 + W5, U5 + V5))

No bonus chaining here—this is the end of the scoring.

Running Total

C6:

=C4

E6:

=C6 + E4

Continue until U6 for the final score.

 

FAQs

How do I create a basic bowling score calculator in Excel?

Start by setting up columns for player names, each frame with two ball scores, and a running total. Use formulas to calculate frame totals and include any necessary bonus points for strikes or spares.

How does Excel know when a strike or spare gets bonus points?

Formulas are made to look ahead into the next one or two rolls, depending on whether it’s a spare or a strike. For example, if a cell contains “X”, Excel adds the next two rolls to calculate that frame’s total.