Apple Keynote '08 - Manual (Page 135)

Chapter 7 Using Formulas and Functions in Tables 135
Here’s a formula that adds the values in nine cells of the first column: SUM(A2:A10).
There is one argument, A2:A10. The colon means the function should use the values
in cells A2 through A10.
Adding a Quick Formula
An easy way to perform a basic calculation using values in a range of adjacent table
cells is to add a quick formula using the Quick Formula pop-up menu on the Format
pane of the Table Inspector.
You can also choose Insert > Function and use the submenu that appears.
Here are operations you can perform using the Quick Formula 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.
Min: Determines which numeric value in the cells is the smallest.
Max: 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 143 for details about this tool.
m Choose Formula Editor to open the Formula Editor. See “Using the Formula Editor” on
page 137 for instructions.