One solution is to have a helper column somewhere with the formula:
=IF(LEN(A1)0,1,0)
Copy the formula down as far as is needed.
Then do a SUM() on that helper column
--
Cutter
------------------------------------------------------------------------
Cutter's Profile:
http://www.excelforum.com/member.php...fo&userid=9848
View this thread:
http://www.excelforum.com/showthread...hreadid=444459