SUMIF.SET function in Excel: uses, formula or syntax and examples

The SUMIF SET function in Excel is responsible for add cells that meet various conditions. It is easy to use, but it is important to know its arguments and uses.

Therefore, in this article we will teach you how to how to use SUMIF SET in Excel By an easy and fast way. With this you can apply different criteria to the data that will be added.

Syntax

The SUMIF SET function in Excel is made up of the following elements:

• sum_range: is the range of cells that will be added. It is a mandatory argument.
• criteria_range1: includes the range of cells where Criterion1 will be evaluated.
• Criterion1: is a mandatory argument since it is the first condition that must be met in the cells of Criteria_Range1 for their values ​​to be added.
• criteria_range2: is an optional element since it will be the second range of cells that will be evaluated by Criterion2.
• Criterion2: will be the condition that must be met within Criteria_Range2.

How to use the SUMIF SET function in Excel?

You can use the following example to use the SUMIF SET function in Excel:

1. Enter the values ​​you need into the spreadsheet. In an available cell, enter “=SUM.IF.SET(”. The sum of medals won by women in the Gymnastics discipline will be used as an example.
2. Now in “sum_range”, selects the entire range of cells from which the data to be added will be obtained. In this case it is “E2:E13”. Insert semicolon to continue.
3. In “criterion_range1“, choose the range where the first criterion must be met. For this example it will be “D2:D13”. Add semicolons.
4. In “criterion1”, type or click on the cell that contains the condition. In this case, you will click on cell “A16” since it has the name “Gymnastics”. In this way, a cell reference will be created and in case of changes, only this box must be modified. Add a semicolon to go to the next argument.
5. In “criterion_range2”, selects the range where the second criterion will be applied. Here it will be “C2:C13”. Enter a semicolon.
6. In “criterion2”, type the second criterion or click on the cell containing the condition to create the cell reference. In this example it will be “Female”, cell “B16”.
7. Close parentheses and press “Enter” to get a result.

In conclusion, when you want to apply several conditions to a set of summed data, use the SUMIF SET function according to the steps mentioned in the post.