| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
{=COUNT(--ISNUMBER(G95:G98))}
G95 = 1
G96 = e G97 = 2 G98 = 3 The count of numbers should be 3. However, I get 4. G96 is formatted as General. =ISNUMBER(G96) resolves to FALSE. So??? -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISNUMBER and IF Functions | Excel Discussion (Misc queries) | |||
| ISNUMBER | Excel Worksheet Functions | |||
| IsNumber & Mid function | Excel Worksheet Functions | |||
| ISNUMBER | Excel Worksheet Functions | |||
| isnumber with sumproduct | Excel Worksheet Functions | |||
Threaded Mode
