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.
Author: Debra Dalgleish
Enter your golf scores in this Excel workbook, for each round of golf that you play during the year.
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.
On the Summary sheet, your overall results for the year are shown.
The Summary worksheet is protected, with no password, to prevent the formulas on this spreadsheet from being accidentally deleted.
The first step is to enter the par for each hole in your golf course, on the Summary sheet.
After each round of golf, enter the date, and your score for each hole, in the light green cells.
The worksheet has conditional formatting, so the cells might change colour, if the scores are par, or below par:
The Scores sheet has an Excel table with a few rows, and it will expand automatically when you start a new row.
On the Summary sheet, your average and best scores are calculated, as well as the number of rounds played.
Also, your best score for each hole is shown, and your average score on 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.
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.
Conditional Formatting for Scores
The CoursePar named range is used in the 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.
Here is the formula that checks if the score in cell B4 is equal to the hole's par:
To find the course par, the OFFSET function:
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
There is also a version of the Golf Scores workbook for multiple players.
The names for the drop down are listed on the AdminLists sheet, in a named Excel table.
At the top of the Summary sheet, there is a drop down list of player names.
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.
There is also a version of the Golf Scores workbook for multiple players, and multiple golf courses.
This is based on the Multi Player workbook, but also has a sheet where you enter gols course information. There are two sample golf course in the workbook.
On the Summary sheet, select a golf course, as well as a player name, to see the results for the selected player and golf course.
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.
4) Multi Players & Golf Courses: Get the zipped Excel Golf Scores - Multi Player / Multi Course workbook. The file is in xlsx format, and does NOT contain any macros.
Table of Contents
Last updated: July 11, 2022 12:10 PM