hammertime44
New Member
- Joined
- Mar 23, 2016
- Messages
- 4
I've built a golf stat tracker for myself. I figured out percentages of greens hit from certain distance to get a percentage.
This is it -
=SUMPRODUCT(($C$1:$C$11130>99)*($C$1:$C$11130<=124)*($A$1:$A$11130="hit"))/SUMPRODUCT(($C$1:$C$55555>99)*($C$1:$C$55555<=124))
However I have another column I need to factor in and cannot figure it out. I won't say the above is perfect but that works.
The next column, in C, has a number in it. 3, 4 or 5. That is the par. So I want to calculate the percentage of greens hit on Par 3 from specific distances, like above. The above are ALL function is for all holes, not specified by Par 3.
Here are a few things I tried but am not getting the correct number:
=SUMPRODUCT(($C$1:$C$150>124)*($C$1:$C$150<=150)*($A$1:$A$150="hit")*($B$1:$B$150="3"))/SUMPRODUCT(($C$1:$C$55555>124)*($C$1:$C$55555<=150))
or
=COUNTIFS($A$1:$A$150,"hit",$B$1:$B$150,"3")/SUMPRODUCT(($C$1:$C$150>124)*($C$1:$C$150<=150))
Thank you for help.
This is it -
=SUMPRODUCT(($C$1:$C$11130>99)*($C$1:$C$11130<=124)*($A$1:$A$11130="hit"))/SUMPRODUCT(($C$1:$C$55555>99)*($C$1:$C$55555<=124))
However I have another column I need to factor in and cannot figure it out. I won't say the above is perfect but that works.
The next column, in C, has a number in it. 3, 4 or 5. That is the par. So I want to calculate the percentage of greens hit on Par 3 from specific distances, like above. The above are ALL function is for all holes, not specified by Par 3.
Here are a few things I tried but am not getting the correct number:
=SUMPRODUCT(($C$1:$C$150>124)*($C$1:$C$150<=150)*($A$1:$A$150="hit")*($B$1:$B$150="3"))/SUMPRODUCT(($C$1:$C$55555>124)*($C$1:$C$55555<=150))
or
=COUNTIFS($A$1:$A$150,"hit",$B$1:$B$150,"3")/SUMPRODUCT(($C$1:$C$150>124)*($C$1:$C$150<=150))
Thank you for help.