# Difference between revisions of "Manuals/calci/COUNTBLANK"

Jump to navigation
Jump to search

Line 1: | Line 1: | ||

=COUNTBLANK(r)= | =COUNTBLANK(r)= | ||

− | *Where r the range | + | *Where r is the range of cells. |

+ | |||

+ | *COUNTBLANK() returns the number of empty or blank cells within a given range. | ||

== Description == | == Description == | ||

Line 69: | Line 71: | ||

| class="sshl_f" | | | class="sshl_f" | | ||

|} | |} | ||

− | |||

− | |||

− |

## Revision as of 15:58, 6 November 2013

# 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 | ||