Thread: Count
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions,microsoft.public.excel.newusers
Gromit12 Gromit12 is offline
external usenet poster
  
Posts: 4
Default Count
Would COUNTA do it for you?

"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