Question

What are the steps to calculate data across worksheet??

Class 10..

Don't spam..​

Answer 1

Answer:

If you want to collect data from multiple sheets into one sheet in the same workbook, you can apply the Consolidate function in Excel.

A.In a new sheet of the workbook which you want to collect data from sheets, click Data > Consolidate.

B.In the Consolidate dialog, do as these:

(1 Select one operation you want to do after combine the data in Function drop down list;

(2 Click to select the range of each sheet you want to collect;

(3 Click Add button to add the data range into the All references list box;

(4 Check the labels you use after combine data, and check Create links to source data option if you want to link the data in combine sheet with source data.

3. Click OK. Now the data have been collect and sum in one sheet.