Difference between revisions of "Manuals/calci/COUNTBLANK"

From ZCubes Wiki
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)
  
*This function calculates empty cells in a particular range of cells.
+
For example, COUNTBLANK(23,45,,"EVEN") ''returns 1 '' as a result.
  
*Cells with empty texts are counted but cells with zero values are not counted.
+
COUNTBLANK(56,"","4/4/2013",,TRUE) ''returns 2 '' as a result.
  
<!--Let’s see an example
+
*This function calculates empty cells or blank values in a particular range of cells.
  
COUNTBLANK (N, D)
+
*Cells with empty texts are counted but cells with zero values are not counted.
 
 
B C
 
 
 
5
 
 
 
16 =IF (C4&lt;40,"", C4)
 
  
30
+
*COUNTBLANK() also calculates the cells with formulas that return an empty text ("").
  
4 14
 
  
<nowiki>=COUNTBLANK (B2:C5) is 3</nowiki>
 
  
</font></div>
 
---- -->
 
 
== 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