When using the "Consolidate" tool, after selecting a group of cells in the "Reference" box, you need to:
B. Click "Add". This action will cause the selected cells to appear in the "All References" box.
After selecting the cells in the "Reference" box, clicking "Add" is the next step to include those cells in the consolidation process. This action ensures that the data from the selected cells will be consolidated or combined as per the chosen function (sum, average, count, etc.) with other selected ranges. It allows you to aggregate data from different ranges into one summary.
