Thread: Count
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Count

In that case, the counta function is what you want. so, =counta(A:A) will
return the number of cells in coluimn A with characters in them. If you have
numbers and letters in a column, and only want to count the number of cells
without numbers, then try =counta(A:A)-count(A:A)

"sdmccabe" wrote:

I guess I am saying count the number of cells occupied by characters (not
numbers) in a given column.

"daddylonglegs" wrote:

Not sure what you mean but COUNT only counts numbers, try COUNTA

"sdmccabe" wrote:

I want to get a total (count) of a column of non-numeric characters €“ each
time I use the auto sum feature and select count, the cursor is placed on the
first cell of the column waiting for a formula. What am I doing wrong?