For the convenience of explanation, I have made an example of a data table.As required, we need to accumulate the total sales in the first quarter.The following are the operation steps: 1. Enter the formula "=SUM()" in the "C3" cell of the "First Quarter Sales" worksheet, and then click the "January Sales" worksheet. 2. Click the C3 cell in the corresponding worksheet, enter a comma, and then click the "February Sales" worksheet. 3. Click the C3 cell in the worksheet, enter a comma again, and then click the "March Sales" worksheet. 4. Click C3 cell in the "Sales Volume in March" worksheet, enter a right bracket, and press Enter to complete the reference of the data corresponding to the previous three worksheets. 5. Now you can see the calculation results in the "First quarter sales volume" worksheet. 6. You can copy this formula to other cells to complete the reference and calculation of other worksheet data. Through the above steps, you can easily complete the data accumulation of multiple worksheets.Please note that in practical applications, please ensure that each data source is correct and contains the expected content.
=OFFSET(Sheet2!$A$1,MATCH($A$17,Sheet2!$A:$A)-1+ROW(A1),COLUMN(A1)) Note: It must be the data in the table, or an error will occur. If you don't want to make mistakes, you can change it to: =IF(COUNTIF(Sheet2!$A:$A,$A$17)0,OFFSET(Sheet2!$A $1, MATCH ($A $17, Sheet2! $A: $A) - 1+ROW (A1), COLUMN (A1)), no such data)
Write the formula as follows: B2=INDIRECT($A2&!B14) C2=INDIRECT($A2&!C14) D2=INDIRECT($A2&!D14) Then select the B2~D2 cell range and pull down the formula.