Consolidate
Combines data from one or more independent cell ranges and calculates a new range using the function that you specify.
рдлрдВрдХреНрд╢рдиреНрд╕
Select the function that you want to use to consolidate the data.
рдХрдВрд╕реЙрд▓рд┐рдбреЗрд╢рди рдХреНрд╖реЗрддреНрд░рд╕реАрдорд╛рдПрдБ
Displays the cell ranges that you want to consolidate.
рд╕реНрд░реЛрдд рдбрд╛рдЯрд╛ рдХреНрд╖реЗрддреНрд░рд╕реАрдорд╛
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.
Copy results to
Displays the first cell in the range where the consolidation results will be displayed.
рдЬреЛрдбрд╝реЗрдВ
Adds the cell range specified in the Source data range box to the Consolidation ranges box.
рд╡рд┐рдХрд▓реНрдк
Shows additional options.