count cells that contain text entries
 

In Excell how would I count cells that contain both text and numbers that are
formated as text?
Example in A1 through A210 there are entries such as ME90.05, M80304, BE80.04

One way:

If you want to count actual numbers, too, use COUNTA():

=COUNTA(A1:A210)

If you want to exclude actual numbers (but not text numbers):

=COUNTA(A1:A210)-COUNT(A1:A210)

In article ,
"Debi" wrote:

In Excell how would I count cells that contain both text and numbers that are
formated as text?
Example in A1 through A210 there are entries such as ME90.05, M80304, BE80.04

JE McGimpsey wrote...
One way:

If you want to count actual numbers, too, use COUNTA():

=COUNTA(A1:A210)

This also includes any error or boolean values in the count.

If you want to exclude actual numbers (but not text numbers):

=COUNTA(A1:A210)-COUNT(A1:A210)

This would also include any error or boolean values in the count.

FWIW, counting just text is fairly simple if obscure.

=COUNTIF(range,"*")

Counting text that could be converted into numbers is a bit trickier,
requiring an array formula.

=COUNT(-range)-COUNT(range)