Please enable JavaScript to view the comments powered by Disqus.


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

Example of Sumifs criteria

The SUMIFS takes multiple arguments to check for multiple criteria. The first argument is the range to be summed. Then it follows with criteria range and criteria respectively, giving the sum following all the conditions mentioned. 


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