SUMIFS(...)+SUMIFS(...)

Category: Math and trigonometry

Adds the cells in a range that meet multiple criteria

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

0

Since SUMIFS() is not an array formula, we need to get the sum individually for each condition using SUMIFS() to get the final count, the two parts calculate the sum for each of the two.