You are complicating your life ...
Use a1:a500, if row 500 is your last row ...
In addition, I would extract your limits into specific cells and use
cell addresses in th countif formula ...

HTH
Carim


--
Carim
------------------------------------------------------------------------
Carim's Profile: http://www.excelforum.com/member.php...o&userid=33259
View this thread: http://www.excelforum.com/showthread...hreadid=530810