Mar 10 2021 11:53 AM
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.
Mar 10 2021 12:30 PM
In T3:
=IFERROR(AVERAGEIFS(tblPutts[Length],tblPutts[Club on approach],S3,tblPutts[Putt],1),"")
Fill down.
Mar 10 2021 02:19 PM
Mar 10 2021 02:42 PM
Can you explain what exactly you want, for someone who doesn't know anything about golf?
Mar 10 2021 02:50 PM
Mar 10 2021 02:56 PM
@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...
Mar 10 2021 03:06 PM - edited Mar 10 2021 03:10 PM
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.
Mar 10 2021 03:21 PM
Solution
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.
Mar 10 2021 03:23 PM
Mar 10 2021 03:21 PM
Solution
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.