| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CountIF cells are not empty
How can I get the CountIf function to count the number of
cells in a range where the cells are not empty? Typ cell contents... 1a 1b 2.1 2.2 (empty) (empty) 3.2.2 3.2.2 ----- total cell count of non empty cells = 6 total number of cells in range = 8 regards Wayne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trendlines to ignore empty cells | Charts and Charting in Excel | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| Sumproduct ... Empty Cells vs Spaces? | Excel Discussion (Misc queries) | |||
| Empty Cells, Spaces, Cond Format? | Excel Discussion (Misc queries) | |||
| empty cells in ranges | Excel Discussion (Misc queries) | |||
Threaded Mode
