Excel How-to
SUMIFS with Multiple Criteria in the Same Column (OR Logic) in Excel & Google Sheets
SUMIFS returns 0 when you give one column two criteria. Sum North OR West with an array constant, a criteria list, FILTER or SUMPRODUCT, without double counting.