Calc Guide

4) In the Calculate subtotals for box, select the columns
containing the values that you want to create subtotals for. If the
contents of the selected columns change later, the subtotals are
automatically recalculated.
5) In the Use function box, select the function that you want to use
to calculate the subtotals.
6) Click OK.
If you use more than one group, then you can also arrange the
subtotals according to choices made on the dialog’s Options page,
including ascending and descending order or using one of the
predefined custom sorts defined in Tools > Options >
OpenOffice.org Calc > Sort Lists.
Figure 225: Choosing options for subtotals
276 OpenOffice.org 3.x Calc Guide