countif

[david]

I want to count the # of cells greater than a calculated
value (reference cell). I get a 0 returned.

Example: =countif(A3:A5,">C5") returns 0.

 

[Vasant Nanavati]

Try:

=COUNTIF(A3:A5,">"&C5)

Concatenating the ">" operator with the cell reference yields the criterion
string.

 

[Jason Morin]

Use ">"&C5

HTH
Jason
Atlanta, GA