How to use table sum sum

Method for table sum sum: First select cell A2; then click the formula option on the page, and click Insert function; then find the SUM function in the pop-up insert function setting box; finally, in the pop-up function parameters In the settings box, click the icon to the right of Number1 to select the range of the required sum.

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

The summation function SUM can be used. How to use it:

Take the excel2010 version as an example. As shown in the figure, there are data in columns B-H, and the data should be totaled in column A;

First select cell A2, then click the formula option at the top of the page, and click Insert Function;

Find SUM in the pop-up insert function setting box function, click the OK button in the lower right corner;

In the pop-up function parameter setting box, click the icon to the right of Number1 to select the range of the required sum;

Select the data between B2 and H2, the dotted line indicates the selected area;

[Recommended learning: Excel tutorial】

Then press the Enter key twice to get the summation result as shown below;

Place the mouse in the lower right corner of cell A2 and pull down By filling in the formula, the data in columns B-H of each row can be added up and summarized in the space of column A of each row.

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