False 6 Consolidate False 0 0 dialog False True vertical 12 False True end _OK True True True True True True Saves all changes and closes dialog. False True 0 _Cancel True True True True True Closes dialog and discards all changes. False True 1 _Help True True True True True False True 2 True False True end 0 True False True True 6 True False True _Function: True func 0 0 0 True False True _Consolidation ranges: True consareas 0 0 2 True False True Sum Count Average Max Min Product Count (numbers only) StDev (sample) StDevP (population) Var (sample) VarP (population) Select the function that you want to use to consolidate the data. 0 1 True True True True in -1 True True True True True liststore1 False 0 False 6 0 Displays the cell ranges that you want to consolidate. 0 3 False True 1 True False 6 True False True True 12 True False True Specifies the cell range that you want to consolidate with the cell ranges listed in the Consolidation ranges box. Select a cell range in a sheet, and then click Add. You can also select the name of a predefined cell from the Source data range list. 0 0 True True True True 50 True Specifies the cell range that you want to consolidate with the cell ranges listed in the Consolidation ranges box. Select a cell range in a sheet, and then click Add. You can also select the name of a predefined cell from the Source data range list. 1 0 True True True Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size. 2 0 0 1 True False True True 12 True False True Displays the first cell in the range where the consolidation results will be displayed. 0 0 True True True True 50 True Displays the first cell in the range where the consolidation results will be displayed. 1 0 True True True Click the Shrink icon to reduce the dialog to the size of the input field. It is then easier to mark the required reference in the sheet. The icons then automatically convert to the Maximize icon. Click it to restore the dialog to its original size. 2 0 0 3 True False True 12 center _Add True True True True True Adds the cell range specified in the Source data range box to the Consolidation ranges box. False True 0 _Delete True True True True True Deletes the selected element or elements without requiring confirmation. False True 1 0 4 True False _Source data ranges: True lbdataarea 0 0 0 True False Copy results _to: True lbdestarea 0 0 2 False True 2 True True True True True True False 6 True True 12 True False True True 0 none True False True True 6 12 6 _Row labels True True False True True True Uses the row labels to arrange the consolidated data. 0 0 C_olumn labels True True False True True True Uses the column labels to arrange the consolidated data. 0 1 True False Consolidate by False True 0 True False True True 0 none _Link to source data start True True True True False True True True 12 6 Links the data in the consolidation range to the source data, and automatically updates the results of the consolidation when the source data is changed. True False Options False True 1 True False Options Shows additional options. False True 3 ok cancel help Combines data from one or more independent cell ranges and calculates a new range using the function that you specify.