How to calculate summation results by manipulating tables

Summation is the most important part of data statistics work. Mastering the method of quick summation can greatly improve work efficiency. For example, you can use functions, formulas, etc. to sum up the data in the table more quickly. However, many users do not know how to get the table summation formula. Below, the editor will tell you about the table summation formula. And how to operate it, friends in need come and learn about it.

Tools/Materials

System version: windows10 system

Brand model: DELLInsdiron 14-3467

Form request How to make sums with formulas

Method 1: Use function formulas to sum

1. We enter "=su" under this string of numbers and a drop-down will appear. We select SUM in the drop-down and press Return Car;

2. The following figure will appear =sum(). We enter A1:A10 in the brackets, or directly position the mouse to the center of the brackets and select the sum you require. data, press Enter;

#3. You can see the summed value.

Method 2: Quick Sum

1. We can see the menu bar, select the area you want to sum, and click on the "Start" menu bar Find a sum button and click the sum button to sum the selected data.

Method 3: Insert function

1. We enter the formula menu. The first three tools can all implement summation.

#2. Click "Insert Function", click "sun", and click "OK".

#3. Position the mouse on "Value 1" and select the data you want to sum.

4. In the returned dialog box, click OK.

#5. Click "Common Functions" to select sum or you can sum. Repeat steps 3 and 4.

Summary:

Method 1: Use function formula to sum

Method 2: Quick summation

Method Three: Insert function

The above is the detailed content of How to calculate summation results by manipulating tables. For more information, please follow other related articles on the PHP Chinese website!