SUMIFS(...)
Sumif example for more then one 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
SUMIFS has ability to take more then one argument as criteria and look into multiple ranges to check for that criteria. Thus when we ant to use two criteria, we will set two arguments for criteria with two lookup ranges to get the final count.