Shulou(Shulou.com)06/02 Report--

This article mainly introduces the realization method of summation in the table, which has a certain reference value and can be used for reference by friends who need it. I hope you will learn a lot after reading this article. Next, let the editor take you to learn about it.

Table summation method: first open the corresponding Excel table; then find the required and the row or column, and locate the cell to this row of data and the location of the location; then click the "insert" menu, select "function"; finally in the dialog box "select function" select "SUM" summation function, and click "OK".

The method of summation in the table:

Open the corresponding Excel table, find the row (or column) that you want to sum, and locate the cell to the and location of the row of data.

Click the insert menu and choose function.

The insert function dialog box appears. In the selection function of the dialog box, the first function "SUM" (that is, "summation") is selected by default. Therefore, click OK.

The function parameters dialog box appears. Enter the location number of the first data and the location 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 location number, as shown in the following figure)

Click OK, and the sum of the row (or column) data appears in the corresponding cell.

Thank you for reading this article carefully. I hope the editor can share the contents of the summation method in the table to help everyone. At the same time, I also hope that you can support us, pay attention to the industry information channel, and find out if you have any problems. detailed solutions are waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.