Thanks form the reply david, my count by color only if a date exist
works fine, it's the cntbycolor if cell contains text not #N/A over
different range that does not work.....i have tried and tried bu
cannot get it to work!

Any thoughts?


Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27633