Function - how to count all cells with text

[Guest]

How can I insert a function that only counts cells with text??

 

[Ron Rosenfeld]

How can I insert a function that only counts cells with text??

Something like:

=SUMPRODUCT(--(ISTEXT(A1:A10)))


--ron

 

[RagDyeR]

Another way:

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

--

HTH,

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

How can I insert a function that only counts cells with text??

 

[Gord Dibben]

=COUNTA(A2:A100)-COUNT(A2:A100)


Gord Dibben MS Excel MVP