Difference between revisions of "Manuals/calci/COUNTBLANK"
(15 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | =COUNTBLANK( | + | <div style="font-size:30px">'''COUNTBLANK ()'''</div><br/> |
− | + | *Parameter is the range of cells or array of data. | |
− | * | + | **COUNTBLANK(), counts the number of blank cells within a range. |
− | |||
− | *COUNTBLANK() | ||
== Description == | == Description == | ||
− | COUNTBLANK( | + | COUNTBLANK() |
− | + | *Data may contain numbers, characters, text, dates, logic values, error values, empty text or blank cells etc. | |
− | *This function calculates empty cells in a particular range of cells. | + | *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. | *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 (""). | ||
+ | *COUNT() can be used to count the non-empty or non-blank cells in the given range except logical values, error values and text. | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
== Examples == | == Examples == | ||
Line 44: | Line 27: | ||
| class="sshl_f" | 5 | | class="sshl_f" | 5 | ||
| class="sshl_f" | 3 | | class="sshl_f" | 3 | ||
− | + | ||
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | 16 | | class="sshl_f" | 16 | ||
| class="sshl_f" | 0 | | class="sshl_f" | 0 | ||
− | | class="sshl_f" | | + | | class="sshl_f" | TRUE |
− | + | ||
|- class="even" | |- class="even" | ||
| class="sshl_f" | | | class="sshl_f" | | ||
− | | class="ssh1_f" | | + | | class="ssh1_f" | 4/4/2011 |
− | | class="sshl_f" | | + | | class="sshl_f" | 0 |
− | + | ||
|- class="odd" | |- class="odd" | ||
| class="sshl_f" | 4 | | class="sshl_f" | 4 | ||
| class="sshl_f " | 14 | | class="sshl_f " | 14 | ||
− | | class="sshl_f" | | + | | class="sshl_f" |=IF(C3=0,"",C3) |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
|} | |} | ||
+ | |||
+ | <div id="5SpaceContent" class="zcontent" align="left"> | ||
+ | |||
+ | |||
+ | =COUNTBLANK(A1:A4) : Counts the number of cells with blank values or empty cells in the range A1 to A4, ''returns 2'' as a result. | ||
+ | |||
+ | |||
+ | =COUNTBLANK(A1:A4,5,"") : Counts the number of cells with blank values or empty cells in the range A1 to A4,a number '5' and blank ("") ''returns 3'' as a result. | ||
+ | |||
+ | |||
+ | =COUNTBLANK(B2:B4) : Counts the number of cells with blank values or empty cells in the range B2 to B4, ''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 with blank values or empty cells in the range C1 to C4, ''returns 1'' as a result. The IF() function returns a blank value in cell C4. | ||
+ | |||
+ | </div> | ||
+ | |||
+ | == Related Videos == | ||
+ | |||
+ | {{#ev:youtube|E47htlup2Lo|280|center|COUNTBLANK}} | ||
+ | |||
+ | |||
+ | == See Also == | ||
+ | |||
+ | *[[Manuals/calci/COUNT| COUNT]] | ||
+ | |||
+ | *[[Manuals/calci/COUNTA | COUNTA]] | ||
+ | |||
+ | *[[Manuals/calci/COUNTIF | COUNTIF]] | ||
+ | |||
+ | ==References== | ||
+ | |||
+ | *[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | ||
+ | *[http://en.wikipedia.org/wiki/Aggregate_function COUNTBLANK] | ||
+ | |||
+ | |||
+ | *[[Z_API_Functions | List of Main Z Functions]] | ||
+ | |||
+ | *[[ Z3 | Z3 home ]] |
Latest revision as of 16:45, 7 August 2018
- Parameter is the range of cells or array of data.
- COUNTBLANK(), counts the number of blank cells within a range.
Description
COUNTBLANK()
- Data may contain numbers, characters, text, dates, logic values, error values, empty text or blank cells etc.
- 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 ("").
- COUNT() can be used to count the non-empty or non-blank cells in the given range except logical values, error values and 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 with blank values or empty cells in the range A1 to A4, returns 2 as a result.
=COUNTBLANK(A1:A4,5,"") : Counts the number of cells with blank values or empty cells in the range A1 to A4,a number '5' and blank ("") returns 3 as a result.
=COUNTBLANK(B2:B4) : Counts the number of cells with blank values or empty cells in the range B2 to B4, 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 with blank values or empty cells in the range C1 to C4, returns 1 as a result. The IF() function returns a blank value in cell C4.
Related Videos
See Also
References