Please enable JavaScript to view the comments powered by Disqus.


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

How to use Sumif with two conditions

The SUMIFS Formula takes as many as 127 arguments for criteria and lookup range making it easy to sum against multiple criteria.  For just 02 ranges we need to put the second criteria argument only twice and leave the additional arguments.


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