SUMIFS Function
Adds up the cells that meet several conditions.
Category
Math & Trig
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
SUMIFS totals the rows where every condition is true — West region and Product A and this month.
Note the order: the range to add comes first, then pairs of criteria range and criteria.
Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
Arguments
| Argument | Required? | What it does |
|---|---|---|
| sum_range | Yes | The cells to add. |
| criteria_range1 | Yes | The first range to test. |
| criteria1 | Yes | The condition for criteria_range1. |
| criteria_range2, criteria2, … | Optional | Up to 126 more range/condition pairs. |
Examples
Example 1 — Region and product
Total Widgets sold in the West.
E2fx=SUMIFS(C2:C6, A2:A6, "West", B2:B6, "Widget")
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Product | Sales | West Widgets | |
| 2 | West | Widget | 620 | 1050 | |
| 3 | East | Widget | 480 | ||
| 4 | West | Gadget | 500 | ||
| 5 | West | Widget | 430 | ||
| 6 | North | Widget | 350 |
=SUMIFS(C2:C6, A2:A6, "West", B2:B6, "Widget") Explain
Example 2 — Between two dates
Use the same date column twice — once for the start, once for the end.
=SUMIFS(C2:C100, A2:A100, ">="&F1, A2:A100, "<="&F2) Explain
Common mistakes
- “OR” conditions. SUMIFS only does AND. For West or East, add two SUMIFS together, or use =SUM(SUMIFS(C2:C6, A2:A6, {"West","East"})).
Notes
- Related functions: SUMIF, COUNTIFS, AVERAGEIFS, SUMPRODUCT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.