Please enable JavaScript to view the comments powered by Disqus.


Getting sum with SUMIF() with two criteria

SUMIF has back draw that we can use it for only one criteria, the alternative is to use SUMIFS() for two condition or more. SUMIFS()'s first argument takes sum_range, afterwards it takes pairs of ranges and criteria to calculate the sum.

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