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