The COUNTBLANK function counts the number of blank cells within a specified range.
For example, if A1 is blank, A2 contains a number, and A3 contains an error message, then the formula
COUNTBLANK(A1..A3)
returns 1.
Note that if a cell contains a formula which returns a blank value (for example, CONCATENATE(" ")), then Ability does not count the cell itself as blank.
See also: