#### hammertime44

##### New Member

- Joined
- Mar 23, 2016

- Messages
- 4

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.