Back to All Formulas
Math & StatsLevel 3: Yellow (Core Formulas & Logic)Difficulty: Intermediate
How to Use SUMIFS in Excel
Sums numerical values across multiple conditions (e.g. Sales in North Region for Q1).
Formula Syntax
=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, )
Arguments Breakdown
| Argument | Requirement | Purpose & Details |
|---|---|---|
| sum_range | Required | The range of numerical cells to add together. |
| criteria_range1 | Required | The first range evaluated against criteria1. |
| criteria1 | Required | The condition that must be met in criteria_range1. |
Step-by-Step Practical Business Example
Suppose you have the following dataset in Excel cells A1:D4:
| Region | Product | Sales Amount |
|---|---|---|
| North | Laptops | 45000 |
| South | Laptops | 32000 |
| North | Monitors | 18000 |
| North | Laptops | 22000 |
Applied Formula:Result: 67,000
=SUMIFS(C2:C5, A2:A5, "North", B2:B5, "Laptops")
How it works: Sums sales amounts only when Region is 'North' AND Product is 'Laptops' (45000 + 22000 = 67000).
Common Errors & How to Fix Them
#VALUE!
Why it happens: sum_range and criteria_ranges do not contain the same number of rows and columns.
Fix: Ensure all ranges start and end at the exact same row (e.g. A2:A50 and C2:C50).
Ready to Master Excel?
Explore 7 LevelsMaster SUMIFS in Level 3
Learn SUMIFS alongside 500+ formulas, hands-on practice workbooks, and verifiable certificates.