Difference between revisions of "Manuals/calci/COUNTBLANK"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">COUNTBLANK (r)</font></font> <font size="3"><font face="Times New Roma...") |
|||
| Line 1: | Line 1: | ||
| − | + | =COUNTBLANK(r)= | |
| − | + | *Where r the range to count the blank cells. | |
| − | + | == Description == | |
| − | + | COUNTBLANK(r) | |
| − | |||
| − | |||
| − | + | *This function calculates empty cells in a particular range of cells. | |
| − | + | *Cells with empty texts are counted but cells with zero values are not counted. | |
| − | |||
| − | |||
| − | < | + | <!--Let’s see an example |
| − | |||
| − | |||
| − | -- | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | Let’s see an example | ||
COUNTBLANK (N, D) | COUNTBLANK (N, D) | ||
| Line 50: | Line 28: | ||
</font></div> | </font></div> | ||
| − | ---- | + | ---- --> |
| + | == 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. | ||
| + | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | + | | class="sshl_f" | | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | class="sshl_f " | | ||
| class="sshl_f" | 5 | | class="sshl_f" | 5 | ||
| class="sshl_f" | 3 | | class="sshl_f" | 3 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| − | + | | class="sshl_f" | 16 | |
| − | | class="sshl_f | ||
| class="sshl_f" | 0 | | class="sshl_f" | 0 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | | class=" " | 30 | + | | class="ssh1_f" | 30 |
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| − | + | | class="sshl_f" | 4 | |
| − | | class="sshl_f | ||
| class="sshl_f " | 14 | | class="sshl_f " | 14 | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="even" |
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
| − | |- class=" | + | |- class="odd" |
| − | |||
| class="sshl_f" | | | class="sshl_f" | | ||
| class="sshl_f" | | | class="sshl_f" | | ||
Revision as of 14:55, 6 November 2013
COUNTBLANK(r)
- Where r the range to count the blank cells.
Description
COUNTBLANK(r)
- This function calculates empty cells in a particular range of cells.
- Cells with empty texts are counted but cells with zero values are not counted.
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 | ||
