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

From Apache OpenOffice Wiki
Jump to: navigation, search
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 4 if cells A1, A2, B1 and B2 are all empty.

See also:

COUNT, COUNTA, COUNTIF, ISBLANK,

Conditional Counting and Summation

Personal tools
In other languages