COUNTBLANK function

[Guest]

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.

 

[RagDyeR]

<<<"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!
=====================================================


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.

 

[Bob Phillips]

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

--
HTH

Bob Phillips

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