Countif

[Harry]

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

[Dav]

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

Regards

Dav

[Harry]

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

"starguy" <[email protected]> wrote in
message news:[email protected]...
>
> try this
> =COUNTIF(A1:G1,A5)
>
>
> --
> starguy
> ------------------------------------------------------------------------
> starguy's Profile:
> http://www.excelforum.com/member.php...o&userid=32434
> View this thread: http://www.excelforum.com/showthread...hreadid=562011
>

[Alan]

=COUNTIF(A1:G1,"<="&A5)
Regards,
Alan.
"Harry" <[email protected]> wrote in message
news:[email protected]...
> 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
>
>

[Dav]

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

Regards

Dav

[starguy]

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.