Difference between revisions of "Manuals/calci/COUNTBLANK"
| Line 50: | Line 50: | ||
| class="sshl_f" |=IF(C3=0,"",C3) | | class="sshl_f" |=IF(C3=0,"",C3) | ||
|} | |} | ||
| + | |||
| + | <div id="5SpaceContent" class="zcontent" align="left"> | ||
| + | |||
| + | |||
| + | =COUNTBLANK(A1:A4) : Counts the number of cells in the range A1 to A4 with blank values or empty cells, ''returns 2'' as a result. | ||
| + | |||
| + | |||
| + | =COUNTBLANK(B2:B4) : Counts the number of cells in the range B2 to B4 with blank values or empty cells, ''returns 0'' as a result. value '0' in B2 cell is considered as a non-blank value. | ||
| + | |||
| + | |||
| + | =COUNTBLANK(C1:C4) : Counts the number of cells in the range C1 to C4 with blank values or empty cells, ''returns 1'' as a result. The IF() function returns a blank value in cell C4. | ||
| + | |||
| + | </div> | ||
| + | |||
| + | == See Also == | ||
| + | |||
| + | *[[Manuals/calci/COUNT| COUNT]] | ||
| + | |||
| + | *[[Manuals/calci/COUNTA | COUNTA]] | ||
| + | |||
| + | ==References== | ||
| + | |||
| + | *[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | ||
| + | *[http://en.wikipedia.org/wiki/Aggregate_function COUNTIF] | ||
Revision as of 16:59, 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 | TRUE |
| 4/4/2011 | 0 | |
| 4 | 14 | =IF(C3=0,"",C3) |
=COUNTBLANK(A1:A4) : Counts the number of cells in the range A1 to A4 with blank values or empty cells, returns 2 as a result.
=COUNTBLANK(B2:B4) : Counts the number of cells in the range B2 to B4 with blank values or empty cells, returns 0 as a result. value '0' in B2 cell is considered as a non-blank value.
=COUNTBLANK(C1:C4) : Counts the number of cells in the range C1 to C4 with blank values or empty cells, returns 1 as a result. The IF() function returns a blank value in cell C4.