Page 212 - TP_IT_V1.0_C10_flipbpookl
P. 212

Step 8:  Select the Data   Consolidate option from the Menu bar.
































              The Consolidate dialog box appears. Note that the reference of the cell B4 of the Final Result sheet is displayed in the
              range Copy results to section, which specify where you want to display the result.

              Step 9:  Click on Source data range drop-down list. The data ranges created earlier will be displayed.

              Step 10: Select the desired data range names.
              Step 11: Click on the Add button.






































              The data ranges will get added up in the Consolidation ranges list box.

              Step 12: Repeat steps 9 to 11 to add data ranges needed for data consolidation.


                210   Trackpad Information Technology (Ver. 1.0)-X
   207   208   209   210   211   212   213   214   215   216   217