Please enable JavaScript to view the comments powered by Disqus.


Sumif with 2 criteria for calculating sum

The SUMIFS Formula takes as many as 127 arguments for criteria and lookup range making it easy to sum against multiple criteria.  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