Count Text Data

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
 
P

Peo Sjoblom

=COUNTA(A2:A200)

will count everything except blanks

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


--


Regards,


Peo Sjoblom
 
W

weewillie

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?
 
R

Roger Govier

Hi
Perhaps you have calculation mode set to Manual

Tools>Options>Calculation>automatic
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Footer text appears "squished" 1
Dealing with the error: unable to filter on excel hc home school 0
Select Text to End of Footnote 9
How to count the numbers in a Word document? 0
Creating a Search using a combo box and then creating a report. 4
Can't seem to delete all images from a Word Doc 2
How to have two tables on same line? 1
Track Changes change in display 0

Top