count cells that contain text entries

[Guest]

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]

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)

 

[Harlan Grove]

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)