COUNTBLANK
Syntax:
COUNTBLANK ( cell-range )
Description: Counts the number of cells in a specified range of cells, which are empty. A cell containing a formula that returns an empty string is counted, whereas a cell containing a zero value is not.
Arguments:
Name |
Type |
Description |
---|---|---|
cell-range |
reference |
Designates the range of cells to be inspected. |
Return Type and Value: number – The number of empty cells in the range specified.
example: