H Harry Jul 17, 2006 #1 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
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 Jul 17, 2006 #4 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
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 Jul 17, 2006 #6 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
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 Jul 17, 2006 #7 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.
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.
