SUMIFS(...)
How to perform excel conditional sum
Used Functions
Category: Math and trigonometry
Adds the cells in a range that meet multiple criteria
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Practice SUMIFS Formula at Sheetzoom
SUMIFS formula at Microsoft help
0
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.