| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| advantage of Database functions | Excel Worksheet Functions | |||
| Automatic Product Functions | Excel Worksheet Functions | |||
| Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
| Automatic Sort with VLOOKUP/LARGE Functions | Excel Worksheet Functions | |||
| Visible rows and functions that work | Excel Worksheet Functions | |||
Linear Mode
