Please enable JavaScript to view the comments powered by Disqus.


How to perform excel conditional sum

The SUMIFS Formula takes as many as 127 conditions and respective lookup range againt those condition to finally give the resulting sum. The first argument is the range to be summed and then it continues with conditional criteria. 

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