Counting text cells

J

Jessica Walton

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
 
P

Peo Sjoblom

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

--

Regards,

Peo Sjoblom


Jessica Walton said:
I have a range of cells A25:A256 that contain text entries of various
Click to expand...
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?
 
A

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,
Jessica Walton said:
I have a range of cells A25:A256 that contain text entries of various
Click to expand...
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?
 
Top