Thread: Count Text Data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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