# Manuals/calci/COUNTBLANK

Jump to navigation
Jump to search

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

Column1 | Column2 | Column3 | Column4 | |

Row1 | 5 | 3 | ||

Row2 | 16 | 0 | ||

Row3 | 30 | |||

Row4 | 4 | 14 | ||

Row5 | ||||

Row6 |