# EXCEL FUNCTION – SUMIFS

## How to use “SUMIFS” function in Excel

SUMIFS function is used to get the “total sum” of values for matching criteria across range.

SUMIFS Function has required arguments i.e. sum_range, criteria_range1, criteria1 and Optional arguments i.e. [criteria_range2, criteria2]… We can place add more than one range to include multiple criteria or conditions.

##### Syntax:
`=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2]…)`
##### Syntax Description:

sum_range argument is used to give cell range; those are to be added together as per the criteria mentioned below

criteria_range1 argument is used to give the range in which criteria1 needs to find

criteria1 argument is used to give criteria for sum. We can give value (example “A”, >10, 50) or cell reference# (example: E2) in this argument

[criteria_range2] optional argument is used to give the ANOTHER range in which criteria2 needs to find

[criteria2] optional argument is used to give criteria2 for sum. Value or cell reference# can be given.

Kindly note, we can add multiple criteria in the function by separating them with Comma (,)

##### Example 1: SUMIFS function with Multiple Criteria

Here, we have details and want to get the total sales of APAC region (criteria1) for Product 1 (criteria2).

• “Column A to C” has Sales details,
• “Column E” shows the sample criteria1, that is to be added,
• “Column F” shows the sample criteria2, that is to be added,
• “Column G” shows the sample formula applied,
• “Column H” shows the output of the function and,
• Explanation is provided in Column “I”

We will be using SUMIFS function as follows:

Hope you learnt this Function,