SUMIFS(...)
Performing sumif with multiple critieria
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 takes multiple arguments to check for multiple criteria. The first argument is the range to be summed. Then it follows with criteria range and criteria respectively, giving the sum following all the conditions mentioned.