Apple Numbers '08 Uživatelský manuál Strana 220
- Strana / 295
- Tabulka s obsahem
- KNIHY
Hodnocené. / 5. Na základě hodnocení zákazníků
220 Chapter 12 Dictionary of Functions
COUNTBLANK
The COUNTBLANK function counts the number of cells in a range that are empty.
COUNTBLANK(range)
 range: A single range of cells.
COUNTIF
The COUNTIF function counts the number of cells in a range that satisfy a condition.
COUNTIF(test-range, condition)
 test-range: The range of cells to be tested.
 condition: The conditional test that results in a logical TRUE or FALSE.
Notes
For more information on the comparison operators you can use in the conditional test,
see “Understanding the Comparison Operators” on page 96.
Examples
Given the following table:
COUNTBLANK(A1:E1) returns 0.
COUNTBLANK(A2:E2) returns 1.
COUNTBLANK(A3:E3) returns 2.
COUNTBLANK(A4:E4) returns 1.
COUNTBLANK(A5:E5) returns 5.
Examples
If cells A1:A8 contain 1, 2, 3, 4, 5, 6, 7, 8:
COUNTIF(A1:A8, "<4") returns 3.
COUNTIF(A1:A8, ">4") returns 4.
COUNTIF(A1:A8, ">=4") returns 5.
- Numbers ’08 1
- User’s Guide 1
- Contents 3
- Contents 7 7
- 8 Contents 8
- Contents 9 9
- 10 Contents 10
- Contents 11 11
- 12 Contents 12
- Contents 13 13
- 14 Contents 14
- Contents 15 15
- Welcome to the 16
- Numbers User’s Guide 16
- Numbers Tools and Techniques 18
- The Numbers Window 20
- Spreadsheet Viewing Aids 21
- Print View 22
- Alignment Guides 22
- The Styles Pane 23
- The Toolbar 24
- The Format Bar 25
- The Inspector Window 25
- Formula Tools 26
- Click to open the 27
- Function Browser 27
- The Media Browser 28
- The Colors Window 28
- The Font Panel 29
- The Warnings Window 29
- Working with a Numbers 31
- Importing a Document 33
- Saving Spreadsheets 34
- Undoing Changes 35
- Viewing Sheets 37
- Adding and Deleting Sheets 38
- Dividing a Sheet into Pages 39
- Using Headers and Footers 41
- Arranging Objects on a Page 41
- Setting Page Orientation 42
- Setting Pagination Order 42
- Numbering Pages 42
- Setting Page Margins 43
- Using Tables 44
- Working with Tables 45
- 46 Chapter 3 Using Tables 46
- Chapter 3 Using Tables 47 47
- Resizing a Table 48
- Moving Tables 48
- Naming Tables 49
- Defining Reusable Tables 49
- 50 Chapter 3 Using Tables 50
- Selecting a Table 51
- Selecting a Table Cell 51
- Selecting a Row or Column 52
- Selecting Table Cell Borders 53
- 54 Chapter 3 Using Tables 54
- Working with Text in Cells 55
- Working with Numbers in Cells 56
- Working with Dates in Cells 57
- Formatting Cell Values 58
- Chapter 3 Using Tables 59 59
- 60 Chapter 3 Using Tables 60
- Chapter 3 Using Tables 61 61
- 62 Chapter 3 Using Tables 62
- Chapter 3 Using Tables 63 63
- 64 Chapter 3 Using Tables 64
- Chapter 3 Using Tables 65 65
- 66 Chapter 3 Using Tables 66
- Monitoring Cell Values 67
- Autofilling Table Cells 68
- Working with Rows and Columns 69
- Adding Columns 70
- Rearranging Rows and Columns 70
- Chapter 3 Using Tables 71 71
- Using a Footer Row 72
- Hiding Rows and Columns 72
- Alternating Row Colors 73
- Working with Table Cells 74
- Formatting Table Cell Borders 75
- Copying and Moving Cells 76
- Adding Comments 76
- Reorganizing Tables 77
- Filtering Rows 78
- Working with Table Styles 79
- Applying Table Styles 80
- Modifying a Table’s Style 80
- Using the Default Table Style 81
- Creating New Table Styles 82
- Renaming a Table Style 82
- Deleting a Table Style 82
- Using Formulas 83
- A Tour of Using Formulas 84
- Adding a Quick Formula 87
- Removing a Formula 88
- Using the Formula Editor 88
- Using the Formula Bar 90
- Using Cell References 91
- Handling Errors and Warnings 93
- Using Operators 94
- Using Functions 96
- Using Charts 98
- Chapter 6 Using Charts 99 99
- Adding a Chart 101
- Editing Charts 102
- Chapter 6 Using Charts 103 103
- Deleting a Chart 105
- Moving a Chart 105
- Using a Legend 106
- Using a Chart Title 107
- Resizing a Chart 107
- Rotating Charts 107
- Chapter 6 Using Charts 109 109
- Chapter 6 Using Charts 111 111
- Pie Charts 113
- Set a pie wedge apart by 114
- Bar and Column Charts 115
- Area Charts and Line Charts 116
- Scatter Charts 117
- 3D Charts 118
- Working with Text 119
- Selecting Text 120
- Smart quotes 128
- Straight quotes 128
- Adjusting Font Smoothing 129
- Aligning Text Horizontally 131
- Aligning Text Vertically 131
- Changing Text Color 133
- Setting a New Tab Stop 135
- Changing a Tab Stop 135
- Deleting a Tab Stop 135
- Setting Indents 136
- Setting Indents for Lists 137
- Using Bulleted Lists 138
- Using Numbered Lists 139
- Adding Text Boxes 141
- Presenting Text in Columns 141
- Putting Text Inside a Shape 142
- Using Hyperlinks 143
- Editing Hyperlink Text 144
- Inserting a Nonbreaking Space 146
- Finding and Replacing Text 148
- Selecting Objects 149
- Deleting Objects 150
- Moving Objects 150
- Aligning Objects 151
- Modifying Objects 154
- Changing the Style of Borders 155
- Framing Objects 156
- Adding Shadows 156
- Adding a Reflection 158
- Adjusting Opacity 158
- Grouping and Locking Objects 159
- Filling Objects 160
- Using the Colors Window 161
- Using Shapes 164
- Making Shapes Editable 165
- Reshaping a Curve 166
- Reshaping a Straight Segment 167
- Using Media Placeholders 170
- Working with Images 171
- Masking (Cropping) Images 172
- Using PDF Files as Graphics 176
- Using Sound and Movies 177
- Adding Address Book Data 179
- Sharing Your Numbers 183
- Spreadsheet 183
- The ColorSync Utility icon 186
- Sending a Spreadsheet to iWeb 187
- Designing Your Own Numbers 188
- Spreadsheet Templates 188
- Dictionary of Functions 193
- Date and Time Functions 195
- Financial Functions 196
- Logical Functions 198
- Information Functions 198
- Reference Functions 199
- Numeric Functions 200
- Trigonometric Functions 201
- Statistical Functions 202
- Text Functions 204
- Function Descriptions 205
- ACCRINTM 206
- AVERAGEA 211
- CONCATENATE 216
- CONFIDENCE 216
- COUNTBLANK 220
- COUPDAYBS 221
- COUPDAYS 221
- COUPDAYSNC 222
- FORECAST 233
- HYPERLINK 236
- INDIRECT 237
- INTERCEPT 238
- Examples 253
- PERCENTILE 256
- PRICEDISC 260
- PRICEMAT 260
- QUOTIENT 263
- RANDBETWEEN 264
- ROUNDDOWN 268
- SUBSTITUTE 277
- SUMPRODUCT 278
- TIMEVALUE 282
- Index 291 291
- 292 Index 292
- Index 293 293
- 294 Index 294
- Index 295 295
Související produkty a manuály pro Software Apple Numbers '08
Software Apple MainStage 3 Uživatelský manuál
(34 stránky)
(34 stránky)
Software Apple iPhoto '08 Uživatelský manuál
(22 stránky)
(22 stránky)
Software Apple Numbers '09 Uživatelský manuál
(288 stránky)
(288 stránky)
Software Apple AppleShare 3.0 Uživatelský manuál
(20 stránky)
(20 stránky)
Software Apple QuickTime 7.2 Uživatelský manuál
(73 stránky)
(73 stránky)
Software Apple Keynote 1 Uživatelský manuál
(100 stránky)
(100 stránky)
Software Apple Xsan 2 Uživatelský manuál
(165 stránky)
(165 stránky)
Software Apple Logic Pro 9 Uživatelský manuál
(357 stránky)
(357 stránky)
Software Apple Numbers '09 Uživatelský manuál
(270 stránky)
(270 stránky)
Software Apple Logic Express 8 Uživatelský manuál
(83 stránky)
(83 stránky)
Software Apple MainStage Uživatelský manuál
(100 stránky)
(100 stránky)
© 2020, manymanuals.cz. Všechna práva vyhrazena. | 0.070 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentáře k této Příručce