Economic and Demographic Upheavals in Society and Family ...

Select Data > Consolidate from the menu. The Consolidate dialog box appears. Click the Function list arrow and select the function you want to use to consolidate the data: for example—Sum, Count or Average. Next, click the Reference button, click the first worksheet tab you want to consolidate, and select the range you want to consolidate. ................
................