Apple Pages 2 - Manual (Page 192)

192 Chapter 8 Creating Tables
Here are some examples of formulas that use functions:
 SUM(A2:A10). This formula uses the SUM function to add values in nine cells of the
first column. There is one argument, A2:A10. The colon means the function should
use the values in cells A2 through A10.
 AVERAGE (A2,B2,C2). This formula uses the AVERAGE function to compute the
arithmetic mean of three values in the second row. There are three arguments: A2,
B2, and C2.
Here’s a summary of the functions you can add using the Insert Formula button.
You can also type these and other functions into the text field of the Formula Editor.
For complete information about all the functions that Pages supports, see “Defining
Formulas That Use Functions” on page 195.
To use a predefined function in a formula:
1 Select an empty cell for displaying the results of the formula.
2 Open the Formula Editor. For example, type the equal sign (=).
3 Click the Insert Formula button, and choose a function from the pop-up menu.
Pages inserts the function into the text field, followed by a pair of parentheses.
4 Within the parentheses, insert references to cells whose values you want the function
to use.
To perform this operation Use this function For example
Sum the values in two or more
cells SUM SUM(A2:A5)
Average the values in two or
more cells AVERAGE AVERAGE(A2:A5)
Determine the smallest value
in two or more cells MIN MIN(A2:A5)
Determine the largest value in
two or more cells MAX MAX(A2:A5)
Determine how many values
in two or more cells are
numbers COUNT COUNT(A2:A5)
Multiply the values in two or
more cells PRODUCT PRODUCT(A2:A5)