# Difference between revisions of "Documentation/How Tos/Calc: COUNTBLANK function"

From Apache OpenOffice Wiki

< Documentation | How Tos

m |
|||

Line 21: | Line 21: | ||

'''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | '''[[Documentation/How_Tos/Conditional Counting and Summation|Conditional Counting and Summation]]''' | ||

+ | |||

+ | [[fr:Documentation/FR/Calc:Fonction NB.VIDE]] |

## Revision as of 21:11, 27 March 2008

## COUNTBLANK

Returns the number of empty cells.

### Syntax:

**COUNTBLANK(range)**

Returns the number of empty cells in the cell range ` range`.

### Example:

**COUNTBLANK(A1:B2)**

- returns
if cells A1, A2, B1 and B2 are all empty.**4**