Excel Count Blank is a built-in
statistical function. It can be used as a worksheet function means as a part of
formula in a cell of a worksheet. The function counts only the number of blank
cells; cells containing text, numbers, errors, etc. are not counted.
Syntax
Countblank(range)
Arguments
Range: REQUIRED. Range of cells to count empty cells
Purpose
To count the empty cells in a range
Return Type
Numeric
Remarks
- Formulas that return empty text (“ ”)are considered blank and will be counted
- Cells containing zero are considered non blank and thus will not be counted
No comments:
Post a Comment