Current location - Quotes Website - Personality signature - How to use the worksheet name as a parameter reference in EXCEL needs to be solved urgently.
How to use the worksheet name as a parameter reference in EXCEL needs to be solved urgently.
1. Start the Excel 20 16 spreadsheet application, and click on the right side of the screen to create a new blank workbook, as shown.

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.