Home  >  Article  >  Software Tutorial  >  How to use excel summation formula How to use excel summation formula

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

WBOY
WBOYOriginal
2024-08-16 12:36:57873browse

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);

excel求和公式怎么用 excel求和公式的使用方法

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

excel求和公式怎么用 excel求和公式的使用方法

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);

excel求和公式怎么用 excel求和公式的使用方法

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);

excel求和公式怎么用 excel求和公式的使用方法

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 excel求和公式怎么用 excel求和公式的使用方法
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); excel求和公式怎么用 excel求和公式的使用方法

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) excel求和公式怎么用 excel求和公式的使用方法

Method 3: Use the sumif function for summing excel求和公式怎么用 excel求和公式的使用方法
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); excel求和公式怎么用 excel求和公式的使用方法

3. The final calculated result is as follows (as shown in the picture). excel求和公式怎么用 excel求和公式的使用方法

Method 4 : Use the subtotal function to perform summationexcel求和公式怎么用 excel求和公式的使用方法
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); excel求和公式怎么用 excel求和公式的使用方法

3. Enter "9" in the "Function Number" and pull the value in "Reference 1" , click "OK" (as shown in the picture);excel求和公式怎么用 excel求和公式的使用方法
excel求和公式怎么用 excel求和公式的使用方法

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).

excel求和公式怎么用 excel求和公式的使用方法

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn