Please enable JavaScript to view the comments powered by Disqus.


How to do Sumif with multiple criteria

The SUMIFS function can take more then one criteria as an argument, thus we can look for them in a single formula that gives us the final count. We usually use logical operators for such comparisons.

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