IBM Lotus Symphony
|
Specify the settings for up to three subtotal groups. Each tab has the same layout. To create subtotal groups, please follow the steps:
Select the column that you want to use to control the subtotal calculation process. The subtotals are grouped by the column you select in this box.
Select the one or more columns containing the values that you want to subtotal.
Select the mathematical function that you want to use to calculate the subtotals. You have to assign function to each selected column individually.
After subtotals are created, you can modify the subtotals by editing the function.
Syntax: SUBTOTAL(function_num:range1:range2:...)
Function_num is the number 1 to 11 that specifies which function to use in calculating subtotals.
Function_num | Function |
---|---|
1 | Average |
2 | Count (numbers only) |
3 | Count |
4 | Max |
5 | Min |
6 | Product |
7 | StDev (Sample) |
8 | StDevP (Population) |
9 | Sum |
10 | Var (Sample) |
11 | VarP (Population) |
Range1, range2... are ranges for which you want to subtotal.