Apple Numbers '08 - Manual (Page 87)

Chapter 5 Using Formulas and Functions in Tables 87
2 To perform another set of instant calculations, select different cells.
If you find a particular calculation very useful and you want to incorporate it into a
table, you can add it as a formula to an empty table cell. Simply drag sum, avg, or one
of the other items in the lower left to an empty cell. The cell doesn’t have to be in the
same table as the cells used in the calculations.
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 pop-up menu visible when you click Function
in the toolbar.
You can also choose Insert > Function and use the submenu that appears.
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 More Functions to open the Function Browser. See “Using Functions” on
page 96 for details about this tool.
m Choose Formula Editor to open the Formula Editor. See “Using the Formula Editor” on
page 88 for instructions.
Performing a Basic Calculation Using Column Values
Using the pop-up menu of the Function button in the toolbar makes it easy to perform
basic calculations on adjacent values in a column and display the results.