#Sumif function in excel how to#

In this case, our first condition is based on the region. вЂcriteria_range1вЂ™: In the вЂ criteria_range1вЂ™ argument select the range where the first condition should be evaluated. вЂsum_rangeвЂ™: In the вЂ sum_rangeвЂ™ argument select the range whose items you want to add up. So, we will try to apply the SUMIFS function as: Objective: Our objective is to find the total units sold from the North region after the date of. LetвЂ™s consider we have a Sales Table as shown below.

#Sumif function in excel how to#

To understand how to use the SUMIFS function letвЂ™s take an example: SUMIFS supports a total of 127 range criteria pairs. вЂ criteria_range2вЂ™, вЂ criteria2вЂ™ specifies the other ranges and their respective conditions. вЂ criteria1вЂ™ specifies the condition that is to be evaluated in the вЂ criteria_range1вЂ™. вЂ criteria_range1вЂ™ specifies the first range where the first criteria is to be evaluated. Here, вЂ sum_rangeвЂ™ specifies the cells that are to be added based on the given conditions. = SUMIFS(sum_range, criteria_range1, criteria1,, вЂ¦) To find the solution we can apply the formula as: LetвЂ™s have a look at some of the examples where SUMIF Function can be used:Д®xample 1: Suppose we have a table as below and now our goal is to find the total units sold in the East Region. Sum_range: In the вЂ sum_rangeвЂ™ argument select the cells that should be added after evaluating the criteria.ДЄfter applying this formula the result comes out as 490688 which is the addition of D3, D7, and D10. Please note that writing вЂњ=NorthвЂќ is the same as writing вЂњNorthвЂќ. Range: In the вЂ rangeвЂ™ argument select the cells that include your criteria.Д¬riteria: In the вЂ criteriaвЂ™ argument enter your criteria i.e. LetвЂ™s try to apply a SUMIF to find the solution. Objective: Our objective is to find the Total Sales Amount earned from the North region. Suppose we have a sales table as shown below: Now letвЂ™s try and understand how to apply a SUMIF formula. If вЂ sum_rangeвЂ™ argument is omitted then SUMIF treats вЂ rangeвЂ™ as вЂ sum_rangeвЂ™. вЂ sum_rangeвЂ™ is an optional argument, it specifies the cells to be added. вЂ criteriaвЂ™ can be a number, expression, or a text string. вЂ criteriaвЂ™ refers to the condition that specifies which items are to be added. Here, вЂ rangeвЂ™ refers to the cells that you want to be evaluated by the вЂ criteriaвЂ™.