Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Creating subtotals"
(New page: {{DISPLAYTITLE:Creating subtotals}} {{Documentation/CG3Ch7TOC |ShowPrevNext=block |PrevPage=Documentation/OOo3_User_Guides/Calc Guide/Consolidating data |NextPage=Documentation/OOo3_User_G...) |
|||
| Line 7: | Line 7: | ||
SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard ('''Insert > Function'''). Because of its usefulness, the function has a graphical interface accessible from '''Data > Subtotals'''. | SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard ('''Insert > Function'''). Because of its usefulness, the function has a graphical interface accessible from '''Data > Subtotals'''. | ||
| − | As the name suggests, SUBTOTAL totals data arranged in a array—that is, a group of cells with labels for columns | + | As the name suggests, SUBTOTAL totals data arranged in a array—that is, a group of cells with labels for columns. Using the Subtotals dialog, you can select up to three arrays, then choose a statistical function to apply to them. When you click '''OK''', Calc adds subtotal and grand total rows to the selected arrays, using the Result and Result2 cell styles to differentiate those entries. By default, matching items throughout your array will be gathered together as a single group above a subtotal. |
To insert subtotal values into a sheet: | To insert subtotal values into a sheet: | ||
| Line 13: | Line 13: | ||
# Ensure that the columns have labels. | # Ensure that the columns have labels. | ||
# Select the range of cells that you want to calculate subtotals for, and then choose '''Data > Subtotals'''. | # Select the range of cells that you want to calculate subtotals for, and then choose '''Data > Subtotals'''. | ||
| − | # In the Subtotals dialog, in the '''Group by''' | + | # In the Subtotals dialog, in the '''Group by''' list, select the column by which the subtotals need to be grouped. A subtotal will be calculated for each distinct value in this column. |
| − | # In the '''Calculate subtotals for''' box, select the columns containing the values that you want to | + | # 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. |
# In the '''Use function''' box, select the function that you want to use to calculate the subtotals. | # In the '''Use function''' box, select the function that you want to use to calculate the subtotals. | ||
# Click '''OK'''. | # Click '''OK'''. | ||
Latest revision as of 17:44, 31 December 2010
SUBTOTAL is a function listed under the Mathematical category when you use the Function Wizard (Insert > Function). Because of its usefulness, the function has a graphical interface accessible from Data > Subtotals.
As the name suggests, SUBTOTAL totals data arranged in a array—that is, a group of cells with labels for columns. Using the Subtotals dialog, you can select up to three arrays, then choose a statistical function to apply to them. When you click OK, Calc adds subtotal and grand total rows to the selected arrays, using the Result and Result2 cell styles to differentiate those entries. By default, matching items throughout your array will be gathered together as a single group above a subtotal.
To insert subtotal values into a sheet:
- Ensure that the columns have labels.
- Select the range of cells that you want to calculate subtotals for, and then choose Data > Subtotals.
- In the Subtotals dialog, in the Group by list, select the column by which the subtotals need to be grouped. A subtotal will be calculated for each distinct value in this column.
- 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.
- In the Use function box, select the function that you want to use to calculate the subtotals.
- 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.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
