Donate SIGN UP
Home > Technology > Counting a column in Excel

Counting a column in Excel

Avatar Image
spotit3 | 21:28 Mon 11th Sep 2006 | Technology
4 Answers
Is it possible to count a column in Excel ? Say I have about 100 rows in a particular column but I only want to count the rows containing text, how do I do it? I am sure I used to be able to do it but haven't worked with computers for a while and seem to have forgotten a lot that I had learned. Probably due to old age!!!!
prev Wireless Netwroks?
  
next itunes question
Gravatar

Answers

1 to 4 of 4rss feed

Best Answer

No best answer has yet been selected by spotit3. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
Avatar Image THECORBYLOON
If the rows are in column A for example,
COUNTA(A1:A100) will count all the non-empty cells.
21:48 Mon 11th Sep 2006
Avatar Image Machecoul
=COUNTIF(A1:A100,">0") counts how many cells have a number in them!!!

Not quite what you wanted.
22:06 Mon 11th Sep 2006
Avatar Image spotit3
Question Author
Thanks a lot. Your answer has brought it all back to me.
22:06 Mon 11th Sep 2006
Avatar Image Machecoul
If you haven't worked it out this does it:

=(COUNTA(A1:A9))-(COUNT(A1:A9))
08:32 Tue 12th Sep 2006

1 to 4 of 4rss feed

Do you know the answer?

Counting a column in Excel

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.