Count values in cell when value is dependent upon value in cell another

[Tennisguuy]

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.

 

[DRSteele]

Unless I'm missing something here, I think you just need the proper syntax for function COUNTIF; you need the &. Like this: =COUNTIF($G$13:$G$207,">="&J5)

 

[Tennisguuy]

Thanks that worked perfectly. Much appreciated.

 

[DRSteele]

You're welcome.