What function is used to add the numbers in table A and the numbers in table B to table C in EXCEL?

What function is used to add the numbers in table A and table B in EXCEL to table C?

First of all, these three tables are in three worksheets of the same EXCEL file, that is, this EXCEL file contains three worksheets, sheet1, sheet2, and sheet3. Table A is in sheet1, and table B is in sheet2. , sheet C is in sheet3. Now we want to add the data of a certain (or some) cell in sheet A and the data of a certain (or some) cell in sheet B and put it into sheet C. In a certain cell, the operation method is as follows:

Click a cell in sheet C of sheet3 and insert the function SUM. In the pop-up "Function Parameters" dialog box, first click the icon to the right of the Number1 row, then select the cell to be added in Sheet1, and return to "Function Parameters" dialog box, then click the icon on the right side of the Number2 row, select the cell to be added in Sheet2, and return to the "Function Parameters" dialog box to confirm.

The final function expression is similar to SUM(Sheet1!A1:C1,Sheet2!B1:D1). The function of this expression is to add the sum of the values ​​in cells A1 to C1 in Sheet1 to the sum of the values ​​in cells B1 to D1 in Sheet2, and then output the result to the corresponding cell in Sheet3.

If you don’t understand, leave me a message and I’ll take a screenshot to show you

excel and formula

Use the sum function in excel to calculate the sum of A3 to A5, A7 to A13, and A15 to A20. There are two methods to calculate.

method one

1. Open the excel table and take any 20 data below as an example for demonstration.

2. At A21, which is the column next to the number 13, enter =A3 A4 A5 A7 A8 ... A13 A15 A16 ... A20, and then press the Enter key to get A3 to A20 The sum of the numbers in between.

Method Two

1. Open the excel table and take any 20 data below as an example for demonstration.

2. Place the mouse at A21, which is the column next to the number 13. Hold down the left mouse button and pull down from A3 to A21.

3. Click the automatic sum in the upper right corner of the table, and then at A21 you can get the sum of the numbers from A3 to A20.

The above is the detailed content of What function is used to add the numbers in table A and the numbers in table B to table C in EXCEL?. For more information, please follow other related articles on the PHP Chinese website!