How to do sum in table

Method for summing in a table: First open the corresponding Excel table; then find the row or column required to be summed, and position the cell to the position where the sum of the row of data is to be placed; then click "Insert" "menu, select "Function"; finally select the "SUM" summation function in the "Select Function" of the dialog box, and click "OK".

The operating environment of this tutorial: Windows 10 system, Microsoft Office Excel2003 software, Dell G3 computer.

Method for summing in a table:

Open the corresponding Excel table, find the row (or column) required to be summed, and position the cell to this row of data and the location to be placed.

Click the "Insert" menu and select "Function".

The "Insert Function" dialog box appears. In the "Select Function" of the dialog box, the first function "SUM" (ie "Sum") is selected by default. So just click OK.

The "Function Parameters" dialog box appears. Enter the position number of the first data and the position number of the last data in "Number 1", separated by ":". (If the required sum is placed directly after the row of data, the software will directly display the summation formula and the corresponding position number, as shown in the figure below)

Click "OK", the sum of the data of the row (or column) will appear in the corresponding cell.

The above is the detailed content of How to do sum in table. For more information, please follow other related articles on the PHP Chinese website!