Z Wiki.openoffice.cz
(Rozdíly mezi verzemi)
|
m |
Řádka 8: |
Řádka 8: |
| <h4><font color="tomato">Syntax</font></h4> | | <h4><font color="tomato">Syntax</font></h4> |
| <p><font color="teal" size=4><b> | | <p><font color="teal" size=4><b> |
- | =COUNTBLANK(Oblasť) | + | =COUNTBLANK(Oblasť)</b></font> |
| <hr> | | <hr> |
| | | |
Řádka 29: |
Řádka 29: |
| <tr> | | <tr> |
| <td align="center" bgcolor="lightgrey">2</td> | | <td align="center" bgcolor="lightgrey">2</td> |
- | <td align="right"></td> | + | <td align="right">1</td> |
| <td></td> | | <td></td> |
| <td align="right"></td> | | <td align="right"></td> |
Řádka 37: |
Řádka 37: |
| <td align="center" bgcolor="lightgrey">3</td> | | <td align="center" bgcolor="lightgrey">3</td> |
| <td align="right"></td> | | <td align="right"></td> |
- | <td></td> | + | <td align="right">3</td> |
| <td align="right"></td> | | <td align="right"></td> |
| <td align="right"></td> | | <td align="right"></td> |
Řádka 44: |
Řádka 44: |
| <td align="center" bgcolor="lightgrey">4</td> | | <td align="center" bgcolor="lightgrey">4</td> |
| <td align="right"></td> | | <td align="right"></td> |
- | <td></td> | + | <td align="right">4</td> |
| <td align="right"></td> | | <td align="right"></td> |
| <td align="right"></td> | | <td align="right"></td> |
Řádka 50: |
Řádka 50: |
| <tr> | | <tr> |
| <td align="center" bgcolor="lightgrey">5</td> | | <td align="center" bgcolor="lightgrey">5</td> |
- | <td align="right"></td> | + | <td align="right">4</td> |
| <td></td> | | <td></td> |
| <td align="right"></td> | | <td align="right"></td> |
Řádka 60: |
Řádka 60: |
| <td></td> | | <td></td> |
| <td align="right">=COUNTBLANK(A2:B11)</td> | | <td align="right">=COUNTBLANK(A2:B11)</td> |
- | <td align="right">20</td> | + | <td align="right">16</td> |
| </tr> | | </tr> |
| <tr> | | <tr> |
Aktuální verze
Funkcia COUNTBLANK(Oblasť)
Účel v programe CALC
Vráti počet prázdných buniek v blasti.
Syntax
=COUNTBLANK(Oblasť)
Príklad
|
A |
B |
C |
D |
1 |
|
|
Vzorec |
Výsledok |
2 |
1 |
|
|
|
3 |
|
3 |
|
|
4 |
|
4 |
|
|
5 |
4 |
|
|
|
6 |
|
|
=COUNTBLANK(A2:B11) |
16 |
7 |
|
|
|
|
8 |
|
|
|
|
9 |
|
|
|
|
10 |
|
|
|
|
11 |
|
|
|
|
Odkazy