I have a column with non-numeric entries (text only). I need to be able to do a simple count of how many entries are in that column. Sounds simple, but all I can find in "Help" are references if the cell has numeric entries. I will actually be doing this for individual columns across the sheet. But I would think what works for one column I could make work for additional columns.
Thanks ... Ken Answer from Richard Rost:
Kenny, just use the COUNTA function. It will count the number of non-blank cells in a range, like:
=COUNTA(A1:A10)
This is different from the COUNT function, which only counts number values.
Hope this helps.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Excel Forum.