COUNTBLANK(list)

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:

Other information functions