SUMIFS with Multiple Conditional AND OR Logic
To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. By default, the SUMIFS function only allows AND logic – when you provide multiple conditions, all conditions must match to be included in the result.