Please enable JavaScript to view the comments powered by Disqus.


Sumif example for more then one criteria

SUMIFS has ability to take more then one argument as criteria and look into multiple ranges to check for that criteria. Thus when we ant to use two criteria, we will set two arguments for criteria with two lookup ranges to get the final count.

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