Page 123 - Excle-En-V3
P. 123
22. Calculations on More Than Three Worksheets
Excel allows merging more than one worksheet and performing calculations
across these sheets. To do this, the structure of the table must be the same and in
the same order across the worksheets, but with different values. For example, to
know the sales of the sales representatives over the months of the year, the names
must be in the same order across the worksheets. And to know the total monthly
sales (note that each month is on a worksheet), a worksheet is created for the total.
Then follow these steps:
Go to the Data tab, and choose the Consolidate tool as shown in the figure:
Figure 178: Consolidate tool
- Choose the desired function. Here it is “sum.”
115 Central Unit for Information Technology Training - Supreme Council of Universities © Intellectual Property Rights 2024
