Please enable JavaScript to view the comments powered by Disqus.


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

How to do sum with sumif and two criteria

For more then two criteria we use SUMIFS rather then SUMIF , because it can handle more then one argument to be summed against. The first argument this formula takes in the range to be summed and then it follow the criteria range and criteria till 217 conditions. 


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