2. Create a workbook document according to the data of the finance department, as shown.
3, select "total sales worksheet-total sales cell data area". Select the Formula → Function Library ribbon, and then click the Insert Function icon.
4. Call up the Insert Function dialog box, as shown. Click "Search Function or Select Category → Mathematical and Trigonometric Functions" and select "Select Function → Sum" function.
5, bring up the "function parameters" dialog box, in the number 1 text box input function parameters in the same cell across multiple worksheets. The complete formula is "= sum ('2065438+the first quarter of 2007: 2065438+the fourth quarter of 2007)! D3:D5).
6. Complete the summary operation by referencing the same cell range of multiple adjacent worksheets.