Apple Numbers '09 - Manual (Page 76)

To display values automatically computed using cell values in a column of a category m
or subcategory, click a category row cell and then click the disclosure triangle.
Click a disclosure
triangle to choose a
computation type.
Choose a numeric computation type (Subtotal, Average, and so on) to display the
results of operations on numeric values (except date, time, or duration values); choose
Count to display a count of nonblank cells.
Count of non-blank cells
To display the kind of calculation being shown, choose Show Function Name from the
pop-up menu after choosing a computation type.
Function name displayed
To remove the contents of a cell in a category row, choose Blank from the cell’s m
pop-up menu.
To display the category name in the cell, choose Category Name instead.
To add a new row to a category or subcategory, choose Add Row Above or Add Row
m
Below from a row’s cell reference pop-up menu. When the new row is added, cells in
the category value columns are assigned the values for the category or subcategory
where the row was inserted.
To hide rows, select them and choose Hide Selected Rows from a row reference tab
m
pop-up menu.
76 Chapter 3 Using Tables