Thread: Count
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 6,953
Default Count
=Counta(A2:A100)

--
Regards,
Tom Ogilvy


"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