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