Then, you can select the range of cells you want to consolidate and choose the function you want to use (SUM, COUNT, AVERAGE, etc.). So, Excel will create a new worksheet that contains the consolidated data.
Then, you can select the range of cells you want to consolidate and choose the function you want to use (SUM, COUNT, AVERAGE, etc.). So, Excel will create a new worksheet that contains the consolidated data.