Hello,
I seem to have no problems with finding averages for my golf worksheet attached.
But what I also need to find is:
total number of holes played -1 par (birdies)
total number of holes played -2 par (eagles)
so on so on. I realise if someone helps me crack the formula to find birdies I can do it for eagles, pars, bogeys myself.
par value is highlighted in cells b2:b52 in "input scores" sheet.
any help would be gratefully received.example worksheet.xlsx
Mark wilson
Bookmarks