60 seconds Interactive Fix
Excel
Verified Office Standard
How to Sum with Multiple Conditions in Excel (SUMIFS Syntax Guide)
SUMIF only supports one condition. When you need to sum sales for a specific region AND a specific product, you must use SUMIFS.
Live browser simulator
Solve it right now
| # | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Region | Status | Amount | ||
| 2 | North | Approved | 500 | ||
| 3 | North | Pending | 300 | ||
| 4 | South | Approved | 400 | ||
| 5 | North | Approved | 700 | ||
| 6 | |||||
| 7 | North Approved Total: | 0 Fixed |
Want to test your skills across 100+ workplace scenarios?
Deskademy simulates real office software with instant grading, hints, and certified CV credentials.
Step-by-step instructions
1
Start with the Sum Range
Unlike SUMIF, SUMIFS begins with the numbers you want to add: =SUMIFS(sum_range, ...).
2
Add First Criteria Pair
Add the first range and condition: =SUMIFS(C2:C10, A2:A10, "North", ...).
3
Add Second Criteria Pair
Add the second range and condition: =SUMIFS(C2:C10, A2:A10, "North", B2:B10, "Approved").
500+ repeated drills
Master Excel in the Deskademy Gym
Drill 10+ repeated variations on this exact topic until it becomes second nature for your next job interview.
More fast office problem fixes
How to Fix #N/A Error in Excel Lookups (IFERROR & XLOOKUP)
→
How to Remove Duplicate Rows in Excel Without Losing Data
→
How to Calculate Average in Excel Ignoring Zeros (AVERAGEIF)
→
How to Combine First and Last Name in Excel (&, CONCAT, TEXTJOIN)
→
How to Extract a ZIP Archive in Windows 11 File Explorer
→
How to Standardize File Names with ISO 8601 Date Format (YYYY-MM-DD)
→
How to Spot and Report a Phishing Email in Microsoft Outlook
→
How to Use CC vs. BCC Correctly in Corporate Email
→
How to Apply Heading 1 and Heading 2 Styles in Microsoft Word
→
How to Center and Align Tables in Microsoft Word Documents
→
How to Redact PII (Personally Identifiable Info) Before Prompting Workplace AI
→