Please enable JavaScript to view the comments powered by Disqus.


Formula for sumif with two conditions

When writing for two condition we need to use SUMIFS() that can handle more then one condition, the first argument it takes is 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