Count, 244 count – Apple iWork '09 User Manual
Page 244
COUNT
The COUNT function returns the number of its arguments that contain numbers,
numeric expressions, or dates.
COUNT(value, value…)
Â
value: A value. value can contain any value type.
Â
value…: Optionally include one or more additional values.
Usage Notes
To count any cell that contains any type of value (that is, any cell that is not empty),
Â
use the COUNTA function.
Examples
The table in this example is used to illustrate all variations of the COUNT function. The information is
not meaningful, but does illustrate what type of arguments each variation of COUNT includes in the
function result.
=COUNT(A1:E1) returns 5, as all arguments are numeric.
=COUNT(A2:E2) returns 0, as none of the arguments are numeric.
=COUNT(A3:E3) returns 3, as the least two cells are not numeric.
=COUNT(A4:E4) returns 0, as the arguments are logical TRUE or FALSE, which are not counted as
numeric.
=COUNT(A5:E5) returns 2, as three cells are empty.
=COUNT(2, 3, A5:E5, SUM(A1:E1), “A”, “b”) returns 5, as the arguments 2 and 3 are numbers, there are
2 numbers in the range A5:E5, the SUM function returns 1 number, and the last two arguments are
text, not numeric (altogether 5 numeric arguments).
Related Topics
For related functions and additional information, see:
“COUNTBLANK” on page 246
“COUNTIFS” on page 248
“Survey Results Example” on page 362
244
Chapter 10
Statistical Functions