Please enable JavaScript to view the comments powered by Disqus.


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

Formula for sumif with two conditions

When writing for two condition we need to use SUMIFS() that can handle more then one condition, the first argument it takes is sum_range, afterwards it takes pairs of ranges and criteria to calculate the 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