Try this:

=COUNTIF(A1:A10,"*")

That counts TEXT only, ignores numbers.

=COUNTA(A1:A10)

That will count all non-empty cells regardless of data type.

--
Biff
Microsoft Excel MVP


wrote in message
...
Hi,

Is there a way I can total up all the cells in a range which have any
text in them what so ever?