Which means that multiple conditions
When we have a large amount of data, but only want to calculate the total amount that meets the specified conditions, we will use SUMIF. For example, when we sell products A, B, and C, but only want to calculate the total sales of product A, that is, we need to meet one condition. Of course, we will not use SUM to slowly enter the summation area, but choose SUMIF.
The SUMIF function window is as follows:
Range: The range where the condition is (in the above example, it is the product column)
Criteria: The condition (in the above example, it is product A)
Sum_range: The sum range (in the above example, it is the sales column)
In this way you can calculate the total
There is an “S” in SUMIFS,need to be met to Peru Phone Number List calculate the total amount, so the application scope is wider. For example, you have two teams A and B to sell products X and Y, and you want to calculate the total sales of product X sold by team A. At this time, you can use SUMIFS.
The window is as follows:sales volume of product
Sum_range: Sum range (that is, the sales column)
Criteria_range 1: Criteria range 1 (that is, the team column)
Criteria 1: Criteria 1 (Team A)
Criteria_range 2: Criteria Cambodia Phone Number range 2 (that is, the product column)
Criteria 2: Criteria 2 (Product X)
