Countif

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

A question about using the countif function.
The example below from office help shows
criteria as a text string (">55").


=COUNTIF(B2:B5,">55")

I wish to use a cell value (ie >C2) instead
of a text value;

=COUNTIF(B2:B5,>C2) but can't seem to enter the
correct syntax to do this; and have numerous
occurances of this, and manually entering a text string
is getting old.

Any help is appreciated.

Paul
 
Back
Top