Please enable JavaScript to view the comments powered by Disqus.


An Example of SUMIFS with multiple criteria

When we have more then one criteria to get sum against we use SUMIFS function. The SUMIFS takes first argument as the range to be summed up. 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


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

Lets chat on this