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

Jump to navigation
Jump to search

Line 3: | Line 3: | ||

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

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

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

Line 9: | Line 9: | ||

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

− | + | For example, COUNTBLANK(23,45,,"EVEN") ''returns 1 '' as a result. | |

− | + | COUNTBLANK(56,"","4/4/2013",,TRUE) ''returns 2 '' as a result. | |

− | + | *This function calculates empty cells or blank values in a particular range of cells. | |

− | + | *Cells with empty texts are counted but cells with zero values are not counted. | |

− | |||

− | |||

− | |||

− | |||

− | |||

− | |||

− | + | *COUNTBLANK() also calculates the cells with formulas that return an empty text (""). | |

− | |||

− | |||

− | |||

− | |||

== Examples == | == Examples == | ||

## Revision as of 16:14, 6 November 2013

# COUNTBLANK(r)

- Where r is the range of cells.

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

## Description

COUNTBLANK(r)

For example, COUNTBLANK(23,45,,"EVEN") *returns 1 * as a result.

COUNTBLANK(56,"","4/4/2013",,TRUE) *returns 2 * as a result.

- This function calculates empty cells or blank values in a particular range of cells.

- Cells with empty texts are counted but cells with zero values are not counted.

- COUNTBLANK() also calculates the cells with formulas that return an empty text ("").

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