Apple iWork '09 - Manual (Page 245)

Chapter 10 Statistical Functions 245
“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
COUNTA
The COUNTA function returns the number of its arguments that are not empty.
COUNTA(value, value…)
 value: A value. value can contain any value type.
 value…: Optionally include one or more additional values.
Usage Notes
To count only cells or arguments that contain numbers or dates, use the COUNT Â
function.
Examples
The table in this example is used to illustrate all variations of the COUNT function, including COUNTA.
The information is not meaningful, but does illustrate what type of arguments each variation of
COUNT includes in the function result.
=COUNTA(A1:E1) returns 5, as all cells contain an argument (all numeric).
=COUNTA(A2:E2) returns 5, as all cells contain an argument (all text).
=COUNTA(A3:E3) returns 5, as all cells contain an argument (mix of text and numeric).
=COUNTA(A4:E4) returns 5, as all cells contain an argument (TRUE or FALSE).
=COUNTA(A5:E5) returns 2, as three cells are empty.
=COUNTA(2, 3, A5:E5, SUM(A1:E1), “A”, “b”) returns 7, as the arguments 2 and 3 are numbers, there are
2 cells that are not empty in the range A5:E5, the SUM function returns 1 number, and “A” and “b” are
text expressions (altogether 7 arguments).