count for characters instead of numbers

R

Ralph Smith

I have used the Count function to let me know how many fields have
numbers in them. If the field is blank or if there are characters in
the field then the Count function does not count the field.

What I would like to do now is to cound all the fields that only have
chacters in them. Is this possible?

Thanks.
 
P

Peo Sjoblom

Assuming fields are cells

=SUMPRODUCT(--(ISTEXT(A2:A100)))

or if you want to count both numbers and text

=COUNTA(A2:A100)
 
Top