Count Text Data
=COUNTA(A2:A200)
will count everything except blanks
post back if you have numbers as well that
should not be counted
--
Regards,
Peo Sjoblom
wrote in message
...
Using 2007 on Vista
If I've got text data which in some columns either has data or there
is a blank, what formula do I use to count how many cells have text in
them per column?
Many thanks
|