<<<"The CountBlank function counts the number of cells with values in
them."

This is *not* true.
It counts "blank" cells.

This counts *numbers*, without counting nulls (zero length text strings):

=COUNT(A:A)

This counts *text*, without counting nulls (zero length text strings):

=COUNTIF(A:A,"*?")

What *exactly are you looking to count?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


"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.