View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Automatic functions

=COUNT(A1:A100) count how many cells in the range have numeric values
Text values are ignored
happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"whispagirl" wrote in message
...
How do I count only those cells that have numbers in them and not letters?
Does someone have a formula or an Excel command to do this that they can
share with me?

Thanks!