Excel SUMIFS function🔀 Sum with several conditions
The SUMIFS function: Sum with several conditions. Sales for this branch, this month. This page shows the syntax, a worked example with its result and how the formula reads.
What does SUMIFS do?
Sum with several conditions. Sales for this branch, this month
SUMIFS syntax
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Arguments in square brackets [ ] are optional · argument names follow Microsoft's documentation
SUMIFS example with the result
=********
👑 Ready-to-use example formula for VIP supporters only · Become VIP
Formula in cell C6 Yellow cells = result
| A | B | C | |
|---|---|---|---|
| 1 | Branch | Month | Sales |
| 2 | Bangna | Jan | 500 |
| 3 | Bangna | Feb | 300 |
| 4 | Silom | Jan | 200 |
| 5 | Bangna | Jan | 100 |
| 6 | Bangna Jan | 600 |
How it reads: Adds column C where branch is Bangna and month is Jan (500 + 100) · the sum range comes first
Frequently asked questions about SUMIFS
What does SUMIFS do?
Sum with several conditions. Sales for this branch, this month
What does the SUMIFS example return?
The example formula in cell C6 gives 600.
Which Excel versions have SUMIFS?
It has been in Excel for many versions and works in the versions in common use today, including Excel for Microsoft 365.
🕸️ More logic formulas and related ones
Source: support.microsoft.com
Checked 17 November 2026 · by Black Sheep Barn · example results are calculated by the app's example engine, for learning