Countif

[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

 

[Peo Sjoblom]

=COUNTIF(Range,">"&Cell)

i.e.

=COUNTIF(B2:B5,">"&C2)

 

[Paul]

Thanks for the quick reply - works great!!

Paul

-----Original Message-----
=COUNTIF(Range,">"&Cell)

i.e.

=COUNTIF(B2:B5,">"&C2)

--

Regards,

Peo Sjoblom





.