Question

What do you find in Consolidation ranges field from Consolidate dialog?​

Answer 1

Answer:

consolidate Dialog

Select the upper-left cell of the area where you want the consolidated data to appear. On the Ribbon, Choose Data > Consolidate to view the Consolidate dialog: In the Function box, click the summary function that you want Excel to use to consolidate the data.

Consolidation ranges

If you have a group of tables (or lists) it is possible to combine (or consolidate) all this data into one table (or list). Your data can be consolidated from several different source, either on the same worksheet, on different worksheets within the same workbook or even in different workbooks.

@loki