ExcelBanter - Automatic functions

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Automatic functions (https://www.excelbanter.com/excel-worksheet-functions/123845-automatic-functions.html)

whispagirl

Automatic functions

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!

Bernard Liengme

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!

whispagirl

Automatic functions

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!

All times are GMT +1. The time now is 04:19 AM.