Countif

H

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
 
H

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
 
D

Dav

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
 
S

starguy

Dav said:
If A5 is text and not the value in cell a5 COUNTIF(A1:G1,"<=A5")
Regards
Dav
Click to expand...

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