countif

  • Thread starter Thread starter david
  • Start date Start date
D

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.
 
Try:

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

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