=ROWS(A1:A10)-COUNTA(A1:A10)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Latika" wrote in message
...
The CountBlank function counts the number of cells with values in them.
Cells with formulas that return "" (empty text) are counted. Cells with
zero
values are not counted. Is there a function that will not count cells
with
formulas that return empty text? Thanks for your help.