Manuals/calci/COUNTBLANK

COUNTBLANK (r)

Where r the range to count the blank cells.

This function calculates empty cells in a particular range of cells.

Cells with empty texts are counted but cells with zero values are not counted.

COUNTBLANK

Syntax

Remarks

Examples

Description

AVEDEV (N1, N2...) Where N1, N 2 ... are positive integers.

Let’s see an example

COUNTBLANK (N, D)

B C

5

16 =IF (C4<40,"", C4)

30

4 14

=COUNTBLANK (B2:C5) is 3