Tennisguuy
Wellknown Member
 Joined
 Oct 17, 2007
 Messages
 550
 Office Version

 2016
 Platform

 Windows
I am having a problem trying to count the values in a column when the value I want to count is greater than or equal to a value in another cell. For example in cell J5 I have the value of 70 and in column G13:G207 I want to count the times the values in column G13:G207 is greater than or equal to 70.
The problem is the value in J5 will change based upon the value the user inputs in J5. Therefore I will not always know what that value is.
I tried this formula =Countif($G$13:$G$207,J5) and it worked if I didn't want to use greater than or equal to. If the value in J5 was never going to change I know I could use this formula =countif($G$13:$G$207,">=70"). The problem I am having is the value can change.
The problem is the value in J5 will change based upon the value the user inputs in J5. Therefore I will not always know what that value is.
I tried this formula =Countif($G$13:$G$207,J5) and it worked if I didn't want to use greater than or equal to. If the value in J5 was never going to change I know I could use this formula =countif($G$13:$G$207,">=70"). The problem I am having is the value can change.