Oh that's Great!! Thank you very much!

"Bernard Liengme" wrote:

=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!