IBM Lotus Symphony


Consolidating Data

The contents of the cells from several sheets will be combined in one place.

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 is 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.

  1. Open the document that contains the cell ranges to be consolidated.
  2. Click Data > Consolidation.
  3. In the Source data range field, select a source cell range to consolidate with other areas.
  4. If the range is not named, click the field next to the Source data area. A blinking text cursor displayed. Type a reference for the first source data range or select the range with the mouse.
  5. Click Add to insert the selected range in the Consolidation ranges field.
  6. Select additional ranges and click Add after each selection.
  7. Specify where you want to display the result by selecting a target range from the Copy results to field.
  8. If the target range is not named, click the field next to Copy results to and enter the reference of the target range. Alternatively, you can select the range using the mouse or position the cursor in the top left cell of the target range.
  9. Select a function from the Function field. The function specifies how the values of the consolidation ranges are linked. The Sum function is the default setting.
  10. Optional: If you prefer to retain links to the source ranges instead of copies, or if you want to consolidate ranges in which the order of rows or columns varies, click the More button in the Consolidation window.
  11. Click OK to consolidate the ranges.
    1. To insert the formulas that generate the results in the target range, click Link to source data. If you link the data, any values modified in the source range are automatically updated in the target range.

      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.

    2. 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, click either Row labels or Column labels.

      To consolidate by row labels or column labels, the label must be contained in the selected source ranges.


Product Feedback | Additional Documentation | Trademarks