Thread: Count
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Huber57 Huber57 is offline
external usenet poster
 
Posts: 74
Default Count

If some have numbers:

=COUNTIF(A1:A100,"*")

That will count any cell with text in it.



"JoJo" wrote:

Folks:



I have a single column of information. Only SOME of the cells within this
column contain a string of alphabetic characters.
Some cells are empty. For example:

Column A
ABC

ZEP


POW
ZAP


* What Excel command would allow me to count the # of cells that actually
contain alphabetic information within a certain range like A2:A100



Thanks,
John.