OpenOffice.org OpenOffice - 3.3 Základní průvodce stáhnout pdf (Strana 243)

• Under Consolidate by, select either Row labels or Column labels if the

cells of the source data range are not to be consolidated corresponding to

the identical position of the cell in the range, but instead according to a

matching row label or column label. To consolidate by row labels or

column labels, the label must be contained in the selected source ranges.

The text in the labels must be identical, so that rows or columns can be

accurately matched. If the row or column label of one source data range

does not match any that exist in other source data ranges, it is added to

the target range as a new row or column.

10) Click OK to consolidate the ranges.

11) If you are continually working with the same range, then you probably want to

use Data > Define Range to give it a name.

The consolidation ranges and target range are saved as part of the document. If you

later open a document in which consolidation has been defined, this data is still

available.

Creating 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 an 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:

1) Ensure that the columns have labels.

2) Select the range of cells that you want to calculate subtotals for, and then

choose Data > Subtotals.

3) In the Subtotals dialog (Figure 241), 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.

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 (Figure 242), including ascending and

descending order or using one of the predefined custom sorts defined in Tools >

Options > OpenOffice.org Calc > Sort Lists.

Chapter 9 Data Analysis 243

1 2 ... 238 239 240 241 242 243 244 245 246 247 248 ... 433 434

Komentáře k této Příručce

Žádné komentáře

OpenOffice.org OpenOffice - 3.3 Základní průvodce Strana 243

Komentáře k této Příručce

Související produkty a manuály pro Software OpenOffice.org OpenOffice - 3.3