# Difference between revisions of "Manuals/calci/COUNTBLANK"

(6 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. | ||

− | + | == Description == | |

− | |||

− | |||

+ | COUNTBLANK() | ||

*Data may contain numbers, characters, text, dates, logic values, error values, empty text or blank cells etc. | *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. | |

− | |||

− | |||

− | |||

− | For example, COUNTBLANK(23,45,,"EVEN") | ||

− | |||

− | 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. | *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 (""). | *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. | *COUNT() can be used to count the non-empty or non-blank cells in the given range except logical values, error values and text. | ||

Line 68: | Line 59: | ||

</div> | </div> | ||

+ | |||

+ | == Related Videos == | ||

+ | |||

+ | {{#ev:youtube|E47htlup2Lo|280|center|COUNTBLANK}} | ||

+ | |||

== See Also == | == See Also == | ||

Line 81: | Line 77: | ||

*[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | *[http://en.wikipedia.org/wiki/Aggregate_function List of Aggregate Functions] | ||

*[http://en.wikipedia.org/wiki/Aggregate_function COUNTBLANK] | *[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

**COUNTBLANK ()**

- 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