Usage of multi-condition sum sumifs in Excel

Condition summation SUMIF usage

Excel/52967.htm"> detailed usage of conditional sum SUMIF in excel click to view details

Multi-condition summation sumifs usage

Sumifs function description

The sumifs function is a function used in excel to filter multiple conditions and sum the data that matches the specified region.
Official notes:
In the area (area: two or more cells on the worksheet. Cells in the area can be adjacent or not adjacent .) Add cells that meet multiple conditions.
This may seem a bit confusing, but don't worry. The literal translation of the English version is so confusing. Let's give you a question ~!
Use instance

A B C
1 Apple database 10
2 banana warehouse receiving 8
3 Apple outbound 6
3. Delivery of bananas 3

If we want to calculate the total number of incoming records for Apple, because the source data is in a table,
We need to use the product name and the incoming and outgoing conditions for filtering. Therefore, we simply use sumif to meet our requirements,
So we need to use the sumifs function. The formula is very simple:
Calculate the number of incoming mails from all Apple

The code is as follows:	Copy code
= SUMIFS (C: C, A: A, "Apple", B: B, "warehouse receiving ")

Calculate the quantity of all bananas

The code is as follows:	Copy code
= SUMIFS (C: C, A: A, "banana", B: B, "warehouse picking ")

Function parameters

The code is as follows:	Copy code
SUMIFS (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],...)

Sum_range
Required. Summation of one or more cells, including numbers or include numbers, names, regions, or cell references (cell reference: used to represent the coordinate set of cells at their position on the worksheet. For example, the reference format of a cell that is displayed at the intersection of column B and row 3rd is "B3 ".). Null Values and text values are ignored.
Criteria_range1
Required. Calculate the first region of the join condition.
Criteria1
Required. Conditions are in the form of numbers, expressions, cell references, or text. They can be used to define which cells in the criteria_range1 parameter will be summed. For example, a condition can be expressed as 32, "> 32 & Prime;, B4," Apple ", or" 32 & Prime ;.
Criteria_range2, criteria2 ,...
Optional. Additional regions and their associated conditions. Up to 127 region/condition pairs are allowed.