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 |
