Count Cells in a particular row w/ text
 

Hi,

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

Count Cells in a particular row w/ text
 

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

if this helps please click yes, thanks

" wrote:

Hi,

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

Count Cells in a particular row w/ text
 

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?

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?

Count Cells in a particular row w/ text
 

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?