Please enable JavaScript to view the comments powered by Disqus.


SUMIFS(...(...D4:D15),(...B4:B15),B17,(...C4:C15),B18)

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

Syntax

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

Lets chat on this