Edit: I highlighted the cells in the attachment with yellow where I'm struggling. The question related to the cells are a): H30, b): AF30, c) S3, d) U3, e) X2.

Hi,

I'm trying to build a statistical golf sheet. From what I found on the forum it was more leaderboard sheets.

On one tab I have data for the courses. Upon entering number of shots I managed using conditional formatting like

,but I'm having some issues with other parts of the spreadsheet.

a) On getting "course par" I want it to only count the number of holes I've played (in case I abort the round due to rain)

When I couldn't get it to work I was so frustrated I did the looong and messy

to cover all 18 holes, but I assume there has to be a better way to complete the task. Any help would be appreciated!

Edit2: I tried
, but there is something wrong with how I try to use it :/

b) For "FW" (fairway) I tried something like

, but it didn't work at all. I'm trying to look through the sheet with the course data and only count the number of holes that have par 4 or higher, but only for the holes I've played.

c) Calculating GIR (Green in regulation) averages.

I started trying something like

to check if anything was entered in the cells in range AC and fetch the value in range AB, but that didn't work.

Since I wasn't calculating these from the beginning I only want to calculate an average for the rounds where I gathered the data and only for that holes I played.

d) To calculate the average for FW I'm thinking I could just manipulate the formula for GIR averages.

e) Calculating birdies

When I googled I understood you couldn't use the colour code to count the number of cells with a particular colour if they were coloured by conditional formatting so I really don't have any idea how to do that in a non-messy fashion :/

Any helpful ideas on how to straighten the question mark into exclamation marks?

Best Regards,

Vigfus

## Bookmarks