During consolidation, the contents of the cells from several sheets will be combined in one place.
Open the document that contains the cell ranges to be consolidated.
From the \
If the range is not named, click in the field next to the \
Select additional ranges and click \
Specify where you want to display the result by selecting a target range from the \
If the target range is not named, click in the field next to \
Select a function from the \
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.
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 does not match any that exist in the target range, it will be appended as a new row or column.
The data from the consolidation ranges and target range will be saved when you save the document. If you later open a document in which consolidation has been defined, this data will again be available.