Countif question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Barb Reinhardt - 18 Jun 2005 23:01 GMT

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

Thanks in advance.

Barb Reinhardt

Reply to this Message

JE McGimpsey - 18 Jun 2005 23:14 GMT

One way:

=COUNTIF(rng, ">B1")

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

Reply to this Message

Bob Phillips - 18 Jun 2005 23:26 GMT

JE means

=COUNTIF(rng,">"&B1)

Signature

HTH

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

> One way:
>
> =COUNTIF(rng, ">B1")
>
> > How do I use COUNTIF if I want the criteria to be greater than the value in
> > cell B1?

Reply to this Message

JE McGimpsey - 19 Jun 2005 01:15 GMT

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

Thanks for the correction.

> JE means
>
> =COUNTIF(rng,">"&B1)

Reply to this Message

Ragdyer - 19 Jun 2005 05:12 GMT

Was the distraction pretty?<g>

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

> You are so right. Once again I shouldn't be posting when distracted...
>
[quoted text clipped - 3 lines]
> >
> > =COUNTIF(rng,">"&B1)

Reply to this Message

JE McGimpsey - 19 Jun 2005 05:31 GMT

> Was the distraction pretty?<g>

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

Reply to this Message