Formulas and Functions
Table Of Contents
- Formulas and Functions
- Contents
- Preface: Welcome to iWork Formulas & Functions
- Chapter 1: Using Formulas in Tables
- The Elements of Formulas
- Performing Instant Calculations in Numbers
- Using Predefined Quick Formulas
- Creating Your Own Formulas
- Removing Formulas
- Referring to Cells in Formulas
- Using Operators in Formulas
- The String Operator and the Wildcards
- Copying or Moving Formulas and Their Computed Values
- Viewing All Formulas in a Spreadsheet
- Finding and Replacing Formula Elements
- Chapter 2: Overview of the iWork Functions
- Chapter 3: Date and Time Functions
- Chapter 4: Duration Functions
- Chapter 5: Engineering Functions
- Chapter 6: Financial Functions
- Chapter 7: Logical and Information Functions
- Chapter 8: Numeric Functions
- Chapter 9: Reference Functions
- Chapter 10: Statistical Functions
- Listing of Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- Additional Statistics
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- ZTEST
- Chapter 11: Text Functions
- Chapter 12: Trigonometric Functions
- Chapter 13: Additional Examples and Topics
- Index
Related Topics
For related functions and additional information, see:
“COUNT” on page 244
“COUNTBLANK” on page 246
“COUNTIF” on page 247
“COUNTIFS” on page 248
“Survey Results Example” on page 362
“Listing of Statistical Functions” on page 225
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
COUNTBLANK
The COUNTBLANK function returns the number of cells in a range that are empty.
COUNTBLANK(range)
 range: A range of cells. range is a reference to a single range of cells, which may
contain values of any type.
Examples
The table in this example is used to illustrate all variations of the COUNT function, including
COUNTBLANK. The information is not meaningful, but does illustrate what type of arguments each
variation of COUNT includes in the function result.
=COUNTBLANK(A1:E1) returns 0, as there are no blank cells in the range.
=COUNTBLANK(A2:E2) returns 0, as there are no blank cells in the range.
=COUNTBLANK(A5:E5) returns 3, as there are three blank cells in the range.
=COUNTBLANK(A6:E6) returns 5, as there are only blank cells in the range.
=COUNTBLANK(A1:E6) returns 8, as there are a total of 8 blank cells in the range.
=COUNTBLANK(A1:E1, A5:E5) returns an error, as COUNTBLANK accepts only one range as an argument.
246 Chapter 10 Statistical Functions