How to use excel summation formula How to use excel summation formula

Guide to use the Excel summation formula. Are you troubled by not knowing how to use the Excel summation formula? Don't worry, this article will explain to you in detail how to use the Excel summation formula. PHP editor Youzi has carefully prepared this tutorial to guide you step by step on how to use the summation formula to help you easily deal with data statistics and calculation problems.

How to use excel summation formula? How to use the excel summation formula

Method 1: Use the sum function to perform the sum

1. Click on a blank cell and enter "=sum("; or click on "fx" above the cell to find the sum function ( As shown in the picture);

2. Pull the data to be calculated in the "=sum()" brackets, and finally click the "Enter" key (as shown in the picture);

3. If If you don't remember the word sum, you can click "fx" above the cell, and a dialog box will pop up. Find "sum" in "Select Function" and click "OK" (as shown in the picture);

4. Pull the data you need to obtain in the value box. If all the data needs to be used, just pull all the data directly in a value box, and finally click "OK" (as shown in the picture);

5. Finally, click on the value calculated by the function, and the calculated data source will be displayed for future viewing (as shown in the picture)

Method 2: Use the sumifs function to perform the sum 1. Click on the cell. "fx" above, find the "sumifs" function in "Select Function", click "OK" (as shown in the picture);

2. Pull the "Sum Area", "Area 1" and "Condition 1" , and finally click "OK", the summed value will be generated (as shown in the picture);

3. After all the data that need to be summed are calculated, click on the summed value to view the data Source (as shown in the picture)

Method 3: Use the sumif function for summing 1. Find the "sumif" function (as shown in the picture);

2. Pull the "area" "Condition" and "Summing Area" data, click "OK" (as shown in the picture);

3. The final calculated result is as follows (as shown in the picture).

Method 4 : Use the subtotal function to perform summation 1. First click on a blank cell and enter "=subtotal", and the blue font "View the operation skills of this function" will be displayed. After clicking, it will jump to a new web page, which will There is a function table. Since the main content of our article is to use Excel for summation, we just remember that the Function_num (including hidden values) of the sum function is 9 (as shown in the picture);

Note: subtotal function It is a little complicated to use, you also need to check Function_num

2. First filter based on the type (it is convenient to pull the data directly, without pulling one value), click on the blank cell, and then click "fx", find the function "subtotal", and finally click "OK" (as shown in the picture);

3. Enter "9" in the "Function Number" and pull the value in "Reference 1" , click "OK" (as shown in the picture);

4. After all values ​​are calculated, click on the value to see the area where the value was finally calculated (as shown in the picture).

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