Home / Computer / How to Sum up the Data in Excel 2016 Table? – iSumsoft

How to Sum up the Data in Excel 2016 Table? – iSumsoft

sum up the data

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.

Way 1: Using AutoSum to sum up data

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.

choose autosum option

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.

move the mouse

Way 2: Enter the formula to sum up data

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.

enter the formula

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.

get the summation data

Way 3: Insert function to sum up data

Step 1: Select the cell behind the data in the first row, and then select the Formula > Insert Function.

insert function

Step 2: In the Insert Function window. Select the SUM function and click OK.

select Sum function

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.

type b2e2 directly

Alternatively, you can also choose to click the button with red arrows behind the edit box.

click the button

This Function Arguments window will appear, select the region to sum over, and then B2:E2 will be displayed in the window.

select the region

Next, you’ll see B2:E2 in the Number1 edit box (see following figure), and finally click OK.

b2e2 displayed

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!

Loading...

>> Source Link

Check Also

Laptop Can't Connect Wifi, Here's How to Fix It!

At this time, who does not need a WiFi connection? With WiFi, we can access …

%d bloggers like this: