Calc Guide

cell of the target range. Copy results to takes only the first cell of
the target range instead of the entire range as is the case for
Source data range.
7) Select a function from the Function list. This specifies how the
values of the consolidation ranges will be calculated. The default
setting is Sum, which adds the corresponding cell values of the
Source data range and gives the result in the target range.
Most of the available functions are statistical (such as Average,
Min, Max, Stdev), and the tool is most useful when you are
working with the same data over and over.
8) At this point you can click More in the Consolidate dialog to
access the following additional settings:
• Select Link to source data to insert the formulas that
generate the results into the target range, rather than the
actual results. If you link the data, any values modified in the
source range are automatically updated in the target range.
Caution
The corresponding cell references in the target range are
inserted in consecutive rows, which are automatically ordered
and then hidden from view. Only the final result, based on the
selected function, is displayed.
• 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.
9) Click OK to consolidate the ranges.
10) 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.
274 OpenOffice.org 3.x Calc Guide