SUMIFS(...)
How to do sum with sumif and two 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
For more then two criteria we use SUMIFS rather then SUMIF , because it can handle more then one argument to be summed against. The first argument this formula takes in the range to be summed and then it follow the criteria range and criteria till 217 conditions.