| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to auto count data in an empty cell to be 0. Blank cell=0
I would like empty cell to automatically set value 0.
For example. sum of largest two values in a row with 2, empty, empty, empty I want the answer to be just 2 as it would if the data was 2,0,0,0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Only Empty Cells AFTER Cells with Data | Excel Worksheet Functions | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
| How do I leave formula cell blank if 2nd reference cell is empty? | Excel Discussion (Misc queries) | |||
| Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
Threaded Mode
