Count Cells in a particular row w/ text

[wotanthewanderer]

Hi,

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

 

[Eduardo]

Hi,
=Counta(A1:A100), will count cells that are not blank

if this helps please click yes, thanks

 

[T. Valko]

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.

 

[wotanthewanderer]

Thanks!

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.

 

[T. Valko]

You're welcome!

--
Biff
Microsoft Excel MVP


Thanks!