SOLVED

# Proximity Tracker

Occasional Contributor

# 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 column T for it to show the average of column E when the value of column C is 1.

9 Replies

# Re: Proximity Tracker

In T3:

=IFERROR(AVERAGEIFS(tblPutts[Length],tblPutts[Club on approach],S3,tblPutts[Putt],1),"")

Fill down.

Thank you

# Re: Proximity Tracker

What if I wanted to track hit/missed greens?

See attached.

# Re: Proximity Tracker

Can you explain what exactly you want, for someone who doesn't know anything about golf?

# Re: Proximity Tracker

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

# Re: Proximity Tracker

@riosborne Does the Putt column still come into this?

And do you mean the average of column E when I or H matches S? The average of I and H appears strange to me since they contain the values that occur in S...

# Re: Proximity Tracker

I think we can ignore the putt column, but I may not be inputting values in a way that is possible to produce the desired outcome.

What I want in column R is an average using columns H and I as "yes or no" values, respectively. For example in line 3, with the number 60 in column S, I want every time that the number 60 shows up in column I or H for it to produce a percentage where column H is a yes, and column I is a no. That possible?

Make sure you are looking at the most recently updated doc.

best response confirmed by riosborne (Occasional Contributor)
Solution

# Re: Proximity Tracker

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.

# Re: Proximity Tracker

you're a genius! Thank you! Hans, I will take you golfing whenever you decide to take up the greatest game in the world