Thread: Count
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
bj bj is offline
external usenet poster
  
Posts: 1,397
Default Count
try = counta(A2:A100)

"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.



Reply With QuoteReply With Quote