Count Cells in a particular row w/ text
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?
|