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