Countif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harry - 17 Jul 2006 12:58 GMT

How do I do a Countif of cells A1:G1 to check if they are equal to or less
than the value in cell A5.

TIA
Harry

Reply to this Message

starguy - 17 Jul 2006 13:18 GMT

try this
=COUNTIF(A1:G1,A5)

Signature

starguy

Reply to this Message

Harry - 17 Jul 2006 13:28 GMT

Thanks for replying but that only works if A1:G1 equals A% and doesn't aloow
for any cell in the range being less than A5

harry

> try this
> =COUNTIF(A1:G1,A5)

Reply to this Message

Dav - 17 Jul 2006 13:23 GMT

=COUNTIF(A1:G1,"<="&A5)

Regards

Dav

Signature

Dav

Reply to this Message

Alan - 17 Jul 2006 13:45 GMT

=COUNTIF(A1:G1,"<="&A5)
Regards,
Alan.

> How do I do a Countif of cells A1:G1 to check if they are equal to or less
> than the value in cell A5.
>
> TIA
> Harry

Reply to this Message

Dav - 17 Jul 2006 14:32 GMT

Two of us have come up with the same solution are your sure it does no
work?
If A5 is text and not the value in cell a5 COUNTIF(A1:G1,"<=A5")

Regards

Da

Reply to this Message

starguy - 17 Jul 2006 14:38 GMT

Dav Wrote:

>
> If A5 is text and not the value in cell a5 COUNTIF(A1:G1,"<=A5")
> Regards
> Dav

< this sign can only be used for numbers not for text.
=COUNTIF(A1:G1,"<=A5") this should work right.

Signature

starguy

Reply to this Message