Countif question

[Barb Reinhardt]

How do I use COUNTIF if I want the criteria to be greater than the value in
cell B1?

Thanks in advance.

Barb Reinhardt

 

[JE McGimpsey]

One way:

=COUNTIF(rng, ">B1")

 

[Bob Phillips]

JE means

=COUNTIF(rng,">"&B1)

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[JE McGimpsey]

You are so right. Once again I shouldn't be posting when distracted...

Thanks for the correction.

 

[Ragdyer]

Was the distraction pretty?<g>

 

[JE McGimpsey]

Was the distraction pretty?<g>

There's only one right answer to that...