You're welcome!

--
Biff
Microsoft Excel MVP


wrote in message
...
Thanks!

On Jun 3, 12:35 pm, "T. Valko" wrote:
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?