One way
=ROWS(A1:A20)-COUNTBLANK(A1:A20)


--
bill k


------------------------------------------------------------------------
bill k's Profile: http://www.excelforum.com/member.php...nfo&userid=821
View this thread: http://www.excelforum.com/showthread...hreadid=444459