COUNTIF (sort of)

[Lxndr]

COUNTIF has been a very nice function to me, but now it is not doing what I need it to do. I want to count all the values in a column (C:C) that is greater than or equal to a value in a particular cell (G3). Unfortunately, countif breaks down for me, at least as far as I know how to use countif.

Could anyone tell me how to do this, either with COUNTIF or with another function or combination of functions? Thank you!

 

[Aladin Akyurek]

On 2002-10-08 13:45, Lxndr wrote:
COUNTIF has been a very nice function to me, but now it is not doing what I need it to do. I want to count all the values in a column (C:C) that is greater than or equal to a value in a particular cell (G3). Unfortunately, countif breaks down for me, at least as far as I know how to use countif.

Could anyone tell me how to do this, either with COUNTIF or with another function or combination of functions? Thank you!

=COUNTIF(C:C,"<="&G3)

shouldn't break if C is of numeric type and G3 houses a number.