View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

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)