Contextures

Excel Golf Scores Workbook

Enter your golf scores, and view your annual summary, in this free Excel workbook. There are single-player and multi-player versions of the workbook.

Golf Scores Workbook Overview

Enter your golf scores in this Excel workbook, for each round of golf that you play during the year.

Enter your golf scores

Microsoft Excel will calculate the totals for front 9 and back 9 holes, and the total score. Then, based on your handicap, a net score is calculated.

net score is calculated

On the Summary sheet, your overall results for the year are shown.

overall results for the year

The Summary worksheet is protected, with no password, to prevent the formulas on this spreadsheet from being accidentally deleted.

Enter Golf Course Information

The first step is to enter the par for each hole in your golf course, on the Summary sheet.

enter the par for each hole

Enter Your Scores

After each round of golf, enter the date, and your score for each hole, in the light green cells.

Enter Your Scores

The worksheet has conditional formatting, so the cells might change colour, if the scores are par, or below par:

  • pars will be coloured orange,
  • scores below par are bright green.

The Scores sheet has an Excel table with a few rows, and it will expand automatically when you start a new row.

View Your Annual Summary

On the Summary sheet, your average and best scores are calculated, as well as the number of rounds played.

Summary sheet, average and best scores

Also, your best score for each hole is shown, and your average score on each hole.

best score for each hole

Finally, there's a tally of your pars, bogeys, birdies, etc., for each hole, using the COUNTIF function. The most frequent type of score is highlighted for each hole.

tally of your pars, bogeys, birdies

How It Works

There's one named range in the workbook -- CoursePar.

The CoursePar range is cell B8 on the Summary Sheet.

To see the name, go to the Formulas tab on the Excel Ribbon, and click the Name Manager command.

one named range in the workbook

Conditional Formatting for Scores

The CoursePar named range is used in the conditional formatting on the Scores worksheet.

  • 1) For cells equal to zero, there is no formatting applied
  • 2) Cells that are equal to the course par score (on the Summary sheet), are coloured orange
  • 2) Cells that are below the course par score (on the Summary sheet), are coloured bright green

conditional formatting on the Scores worksheet

OFFSET Formula Checks Hole Par

For Rules 2 and 3, the OFFSET function returns the course par for the applicable hole.

first hole score in cell B4

Here is the formula that checks if the score in cell B4 is equal to the hole's par:

  • =B4=OFFSET(CoursePar,0,COLUMN()-1)

To find the course par, the OFFSET function:

  • starts at the named range, CoursePar -- cell B8 on the Scores sheet
  • moves down zero rows
  • moves to the right, based on the first hole column on the Scores sheet (column 2), minus 1

So, for the first hole, the OFFSET function returns the par score that is 1 column to the right of the named range, CoursePar (column 2, minus 1) -- cell C8

first hole par on summary sheet

Multiple Players

There is also a version of the Golf Scores workbook for multiple players.

  • On the Scores sheet, there is a column for player names.
  • Select a player name from the drop down list in that column

column for player names

The names for the drop down are listed on the AdminLists sheet, in a named Excel table.

  • You can add new names at the end of the table, and the table will automatically expand to include them.
  • The name list can be sorted alphabetically, to make the names easier to find.

player list

At the top of the Summary sheet, there is a drop down list of player names.

  • Select a name, and see the results for that person.

player list on Summary sheet

On the SummaryALL sheet, a pivot table shows results for all the players - number of rounds, best score, average score, best net, and average net.

Be sure to refresh this pivot table, after you add any new scores in the workbook.

summary for all playerst

Get the Workbook

1) Single Player: Download the zipped workbook: Excel Golf Scores . The file is in xlsx format, and does NOT contain any macros.

2) Multi Player: Get the zipped Excel Golf Scores - Multi Player workbook. The file is in xlsx format, and does NOT contain any macros.

3) Multi Player - 9 Holes: Get the zipped Excel Golf Scores - Multi Player - 9 Holes workbook. The file is in xlsx format, and does NOT contain any macros.

Related Pages

Golf Tee Off Times

COUNT / COUNTIF

SUBTOTAL

SUM / SUMIF

VLOOKUP

 

Last updated: May 10, 2022 9:05 PM