SUMIFS(...)
An Example of SUMIFS with multiple criteria
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
When we have more then one criteria to get sum against we use SUMIFS function. The SUMIFS takes first argument as the range to be summed up. Then it follows with criteria range and criteria respectively, giving the sum following all the conditions mentioned.