Apple Numbers '09 - Manual (Page 121)

Chapter 6 Using Formulas in Tables 121
Maximum: Determines the largest numeric value in selected cells
Count: Determines the number of numeric values and date/time values in
selected cells.
Product: Multiplies all the numeric values in selected cells.
You can also choose Insert > Function and use the submenu that appears.
Empty cells and cells containing types of values not listed are ignored.
Here are ways to add a quick formula:
To use selected values in a column or a row, select the cells, click Function in the
m
toolbar, and then choose a calculation from the pop-up menu.
If the cells are in the same column, Numbers places the formula in the first empty
cell beneath the selected cells. If there is no empty cell, Numbers adds a row to hold
the formula.
If the cells are in the same row, Numbers places the formula in the first empty cell to
the right of the selected cells. If there is no empty cell, Numbers adds a column to hold
the formula.
To use
m all the values in a column’s body cells, click the column’s header cell or
reference tab, click Function in the toolbar, and then choose a calculation from the
pop-up menu.
Numbers places the formula in a footer row. If a footer row doesn’t exist, Numbers
adds one.
To use
m all the values in a row, click the row’s header cell or reference tab, click Function
in the toolbar, and then choose a calculation from the pop-up menu.
Numbers places the formula in a new column.
Creating Your Own Formulas
Although you can use several shortcut techniques to add formulas that perform
simple calculations (see “Performing Instant Calculations” on page 119 and “Using
Predefined Quick Formulas” on page 120), when you want more control you use the
formula tools to add formulas.