Manuals/calci/COUNTBLANK

Revision as of 15:58, 6 November 2013 by Swapna (talk | contribs)

COUNTBLANK(r)

  • Where r is the range of cells.
  • COUNTBLANK() returns the number of empty or blank cells within a given range.

Description

COUNTBLANK(r)

  • 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.

Examples

Consider the following table with different types of data in various columns.

COUNTBLANK() counts the number of blank or empty cells in the given range.

5 3
16 0
30
4 14