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.
Let’s see an example
COUNTBLANK (N, D)
16 =IF (C4<40,"", C4)
=COUNTBLANK (B2:C5) is 3