When to use a SUM(IF()) array formula - Microsoft Support

You can use the SUMIF() worksheet function in Microsoft Excel for either of the ... array constants, nested IF statements or Boolean operators; or you want one ...

support.microsoft.com