[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
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 |
Designates the range of cells to be inspected. |
Return Type and Value: number – The number of empty cells in the range specified.
[Example:
COUNTBLANK(A2:C2), where A2 and B2 are empty, but C2 is not, results in 2
end example]