Countif
 

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

Countif
 

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

Countif
 

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

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=562011

Countif
 

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" wrote in
message ...

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

Countif
 

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

Countif
 

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


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=562011

Countif
 

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.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=562011