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