Forum Discussion
Solved
Proximity Tracker
Hi, I'm a golfer and I'm trying to track the average distance to the hole sorted by the club. Basically, I think I need an equation that goes something like, if column S matches column H, in colu...
Try this in R3:
=IFERROR(COUNTIF(tblPutts[Club on approach],S3)/COUNTIF(tblPutts[[Club on approach]:[Miss Green?]],S3),"")
Format R3 as a percentage, then fill down.
In T3:
=IFERROR(AVERAGEIFS(tblPutts[Length],tblPutts[Club on approach],S3,tblPutts[Putt],1),"")
Fill down.
Can you explain what exactly you want, for someone who doesn't know anything about golf?
- Oops! I thought everyone played golf 🙂
I want column R to produce an average of columns I and H but only if the value in columns H or I are the same as column S. That make sense?
So if the number is column H it means I hit the green (positive). If the number is column I it means I missed the green (negative). I'd like column R to produce the average of those two columns when the value is the same as whats in column S.
I think I explained that correctly but lmk if its still confusing. Thank you so so much.
So if the
- Thank you
