SUMIFS(...)+SUMIFS(...)
How to get sum thorough sumifs OR condition
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
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.