Count Text Data

  • Thread starter Thread starter weewillie
  • Start date Start date
W

weewillie

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
 
=COUNTA(A2:A200)

will count everything except blanks

post back if you have numbers as well that
should not be counted


--


Regards,


Peo Sjoblom
 
Thanks

I did just that
In my case it's " =COUNTA(A2:A1293)"
I then dragged this formula along the bottom of each column
Despite some columns have less data than in col a, all columns show
the same result 1292
How can this be?
 
Hi
Perhaps you have calculation mode set to Manual

Tools>Options>Calculation>automatic
 
Back
Top