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
|