count cells that contain text entries

D

Debi

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
 
J

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)
 
H

Harlan Grove

JE McGimpsey wrote...
One way:

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

=COUNTA(A1:A210)
Click to expand...

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)
Click to expand...

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)
 
Top