Excel SUMIFS: Sum with Multiple Criteria

By Szabó Gergő · Updated Aug 31, 2026

SUMIFS adds values only when every supplied condition is met. It is ideal for totals constrained by combinations such as region, status, owner, or date range.

Syntax and arguments

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

sum_range: The numeric cells to add.
criteria_range1: The first range to evaluate.
criteria1: The condition for the first criteria range.
additional pairs: Optional range-and-condition pairs; all conditions must be true.

SUMIFS examples

Sum paid sales in one region

Amount is D, region is B, and status is C.

=SUMIFS(D2:D500,B2:B500,F2,C2:C500,"Paid")

A row contributes only when its region equals F2 and its status is Paid.

Sum values within a date range

Dates are A, amounts are D, start date is F2, and end date is G2.

=SUMIFS(D2:D500,A2:A500,">="&F2,A2:A500,"<="&G2)

Two conditions on the date column create an inclusive date window.

Exclude canceled orders

Amounts are E and statuses are C.

=SUMIFS(E2:E300,C2:C300,"<>Canceled")

The <> operator includes rows whose status is not Canceled.

Common mistakes

Using SUMIF argument order
In SUMIFS, put sum_range first, followed by criteria range and criteria pairs.
Ranges have different dimensions
Every criteria range must have the same rows and columns as sum_range.
Dates are typed into formula text
Prefer date cells or DATE(year,month,day) to avoid locale-dependent date parsing.

SUMIFS FAQ

Does SUMIFS use AND or OR logic?

Conditions in one SUMIFS use AND logic. For OR logic, add separate SUMIFS results or use an array approach.

Can SUMIFS use wildcards?

Yes. Use * for any number of characters and ? for one character in text criteria.

How do I sum the current month?

Use a start criterion on the first day and an exclusive end criterion on the first day of the next month.