Thread: Count
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Count
Check your other post, too.

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.

--

Dave Peterson
Reply With QuoteReply With Quote