Please enable JavaScript to view the comments powered by Disqus.


Performing sumif with multiple critieria

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


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

Lets chat on this