How to use SUMIFS function in excel(with Examples)Excel SUMIFS Function

What is the SUMIFS function in Excel?

The SUMIFS function is one of the math functions of Excel. it Adds the cells specified by a

given set conditions or criteria.

We can find this function in Math&trig of insert function Tab.

Table of Contents

1.Click on an empty cell (like F5).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select math and trig category

5. Select SUMIFS function

6. Then select ok

7. In the function arguments Tab you will see SUMIFS function

8. Sum_range are the actual cells to sum. in Sum-range box you must enter column that want to sum.

9&11. Criteria_range1 is the range of cells you want to be evaluated for the particular condition.

10&12. Criteria_1 is the condition in form of a number, expression, or text that defines which cells will be added.

13. You will see results in the formula result section

=SUMIFS(D2:D13,A2:A13,2022,B2:B13,"Cristiano Ronaldo")
----->>>>answer is 43

Example 1:

In the following example, as you can see in the photo, diffrent Criteria in sumifs Function can be identified by the SUMIFS function.

The SUMIFS function supports logical operators (>,<,<>,=) and wildcards (*,?) .The table below shows some common examples:

=SUMIFS(D2:D13,A2:A13,">2022")
----->>>>answer is 87

Example 2:

In the following example, as you can see in the photo, Multiple Conditions in sumifs Function can be identified by the SUMIFS function.

=SUMIFS(D2:D13,A2:A13,"2022",B2:B13,"*R*")
----->>>>answer is 87