| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Please help me decipher the result of COUNT.
Following data from A1:A7
Sales 12/8/2008 19 22.24 TRUE #DIV/0! =COUNT(A1:A7,2) returns 4. I don't understand where the four occurrences of 2 come from. 22.24 = 3 occurrences 12/8/2008 = 2 occurrences total of 5?? I know I am missing something. Please tell me. Is there a tool that I can use to trace? I tried the formula auditing toolbar, no luck because there is no error and trace precedents is not detailed enough. Appreciate explanation. Epinn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
| how to use spellnumber formula | Excel Worksheet Functions | |||
| VBA | Excel Worksheet Functions | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| Spellnumber | Excel Worksheet Functions | |||
Threaded Mode
