In daily work, Excel table is a good helper for statistical data. Sometimes, we need to use Excel table to make statistic data, for example, make the statistics of student performance, the statistics of company product price list or expense report. Now, this is going to involve how to sum up the data in the Excel table, so how do you sum up the data in the Excel table? Here are three different approaches provided for you.
3 Ways to sum up the data in Excel 2016 table
If you store data such as price lists or reimbursement forms in Excel, you may need a quick way to sum up the price or amount. Today I’ll show you how to easily sum up data in Excel 2016 table.
Step 1: Open the Excel table you want to sum up, select the first row of data, and then click the “AutoSum” button to choose Sum option in the upper right corner of the top toolbar.
Step 2: We will see that the result of the sum will appear in the cell at the end of the data area we selected. At this point, we select the cell with the result of the sum and move the mouse to the lower right corner of the cell until the mouse pointer changes to a solid cross shape. Once you see this solid cross shape appears, you pull down until it gets the summation data for all of this column.
Step 1: Enter the formula: =B2+C2+D2+E2 in the cell behind the data in the first row. After finished the input, click any position of the extra edge of the cell.
Step 2: Then we can use the previous method to drag the sign of the cross shape, and then all the data of the sum will be displayed.
Step 1: Select the cell behind the data in the first row, and then select the Formula > Insert Function.
Step 2: In the Insert Function window. Select the SUM function and click OK.
Step 3: Type B2:E2 directly in the Number1 edit box, and then hit ok. At last, use the previous method to drag the sign of the cross shape, and then all the data of the sum will be displayed.
Alternatively, you can also choose to click the button with red arrows behind the edit box.
This Function Arguments window will appear, select the region to sum over, and then B2:E2 will be displayed in the window.
Next, you’ll see B2:E2 in the Number1 edit box (see following figure), and finally click OK.
The above is 3 ways of summing up the data in the Excel 2016 table. It’s a very simple operation. Have you learned them? Hopefully, this article will be of help to you!
>> Source Link