Assuming your range is A1:A10 you could use

=COUNTBLANK(A1:A10)

Formulas in your range that return "" are counted but zeros are not.

HTH

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=528661