The Excel SUMIFS function adds the cells that meet every condition you give it — multiple AND criteria across as many columns as you need.
Syntax
| Argument | Description | |
|---|---|---|
sum_range | Required | The cells to add. Unlike SUMIF, this comes first. |
criteria_range1 | Required | The first range to test. |
criteria1 | Required | The condition applied to criteria_range1. |
criteria_range2, criteria2, ... | Optional | Up to 127 additional range/criteria pairs. All conditions must be met (logical AND). |
How to use it
SUMIFS flips the SUMIF order: the sum range comes first, then one or more range, criteria pairs. A row is added only when it satisfies all conditions.
Every criteria range must be the same size as sum_range. Criteria follow the same rules as SUMIF: quote operators and text, use & to reference cells, and use */? wildcards.
Date ranges: to sum between two dates, use two conditions on the same column — ">="&startdate and "<="&enddate.
Try it: interactive demo
Pick a SUMIFS example to see the formula and its result.
Practice workbook
Frequently asked questions
Why does SUMIFS put the sum range first?
Does SUMIFS use AND or OR logic?
How do I sum between two dates?
=SUMIFS(C2:C6,D2:D6,">="&G1,D2:D6,"<="&G2) sums rows whose date falls between G1 and G2.Why does SUMIFS return a #VALUE! error?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class