Please enable JavaScript to view the comments powered by Disqus.


An Example of Sumifs criteria

Unlike SUMIF, the formula SUMIFS is able to handle multiple criteria and multiple lookup ranges to sum for a given condition, for this case we have two criteria and two lookup ranges to get the final sum.  

Used Functions

Category: Math and trigonometry

Adds the cells in a range that meet multiple criteria


SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Lets chat on this