Counting text cells

[Guest]

I have a range of cells A25:A256 that contain text entries of various types (doesn't matter). How do I get it in cell A258 to give me a total of cells that have text in them within that range 25:256

Thanks, Gurus
Jessica

 

[Peo Sjoblom]

=SUMPRODUCT(--(ISTEXT(A25:A256)))

--

Regards,

Peo Sjoblom

I have a range of cells A25:A256 that contain text entries of various

types (doesn't matter). How do I get it in cell A258 to give me a total of
cells that have text in them within that range 25:256?

 

[Alan]

=COUNTA(A1:A22)
=COUNTIF(A1:A23,"<>"&0)

These will give the count of cells that are not empty, however they will not
distinguish text from numbers, just cells that aren't empty.
Regards,

I have a range of cells A25:A256 that contain text entries of various

types (doesn't matter). How do I get it in cell A258 to give me a total of
cells that have text in them within that range 25:256?