SUMIFS

Sum values meeting multiple criteria simultaneously. Always prefer SUMIFS over SUMIF — it handles multiple criteria and has a more consistent argument order. Pair with structured table references for maintainable formulas.

Syntax

excel-mastery

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

Example

excel-mastery

=SUMIFS(SalesTable[Amount], SalesTable[Region], "West", SalesTable[Quarter], "Q4")

=SUMIFS(Orders[Revenue], Orders[Date], ">="&StartDate, Orders[Date], "<="&EndDate)