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.

<<<"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" <(E-Mail Removed)> wrote in message
news:A5D277D6-E0E8-4AEE-AAB2-(E-Mail Removed)...
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.

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

--
HTH

Bob Phillips

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

"Latika" <(E-Mail Removed)> wrote in message
news:A5D277D6-E0E8-4AEE-AAB2-(E-Mail Removed)...
> 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.
>
>