SUMIFS(...)
How to use Sumif with two conditions
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 arguments for criteria and lookup range making it easy to sum against multiple criteria. For just 02 ranges we need to put the second criteria argument only twice and leave the additional arguments.