count if greater than value?

[megaman666]

im trying to count the number of values in a column that are greater than 43, cant seem to get it....

=COUNTIF(OPEN!$H:$H,>42) would have been my assumption, apparently you cant do that.

 

[Peter_SSs]

im trying to count the number of values in a column that are greater than 43, cant seem to get it....

=COUNTIF(OPEN!$H:$H,>42) would have been my assumption, apparently you cant do that.

You need some quotes

=COUNTIF(OPEN!$H:$H,">42")

Also, I'd recommend using a smaller range if possible. Waste of time checking over a million rows if you are only using a few hundred, say

=COUNTIF(OPEN!$H2:$H1000,">42")

 

[megaman666]

doh. thanks

 

[Peter_SSs]

No problem. Check that you saw my edit as well.