Apple Pages '08 - Manual (Page 193)

Chapter 9 Using Formulas and Functions in Tables 193
Here are operations you can perform using the pop-up menu or submenu:
m Choose one of the following to perform calculations using values in the selected cells.
Empty cells and cells containing values that aren’t mentioned are ignored.
Sum: Totals numeric values in the cells.
Average: Calculates the arithmetic mean of numeric values in the cells.
Minimum: Determines which numeric value in the cells is the smallest.
Maximum: Determines which numeric value in the cells is the largest.
Count: Determines how many of the values in the cells are numeric or date/time
values.
Product: Multiplies all the numeric values in the cells.
m Choose Insert > Function > More Functions to open the Function Browser. See “Using
Functions” on page 200 for details about this tool.
m Choose Formula Editor to open the Formula Editor. See “Using the Formula Editor” on
page 194 for instructions.
Performing a Basic Calculation Using Column Values
Using the Table Inspector’s Quick Formula pop-up menu makes it easy to perform basic
calculations on adjacent values in a column and display the results.
Here are ways to perform basic calculations using values in a column:
m To use values in a range of adjacent cells, select the cells, click Inspector in the toolbar,
click the Table Inspector button, and then click Format. Choose a formula from the
Quick Formula pop-up menu.
Pages places the formula and its result in the first empty cell beneath the selected cells.
If there is no empty cell, Pages adds a row to hold the result.
m To use all the values in a column, click the column’s header cell or reference tab. In the
Table Inspector, click Format, and then choose a formula from the Quick Formula pop-
up menu.
Pages places the formula and its result in a footer row. If a footer row doesn’t exist,
Pages adds one.
Performing a Basic Calculation Using Row Values
Using the Table Inspector’s Quick Formula pop-up menu makes it easy to perform basic
calculations on adjacent values in a row and display the results.
Here are ways to perform basic calculations using values in a row:
m To use values in a range of adjacent cells, select the cells, click Inspector in the toolbar,
click the Table Inspector button, and then click Format. Choose a calculation from the
Quick Formula pop-up menu.
Pages places the formula and its result in the first empty cell to the right of the selected
cells. If there is no empty cell, Pages creates a column to hold the result.