Goal: Sum the Sales only if they meet specific criteria.
SUMIF: 1 Condition. SUMIFS: 2+ Conditions.
Ready...
💻 Formula Structure
=SUMIF(range, criteria, [sum_range])
- 1. Range: Where to look (e.g., Regions).
- 2. Criteria: What to look for ("East").
- 3. Sum Range: What to add (Sales).
=SUMIFS(sum_range, crit_range1, crit1, ...)
- 1. Sum Range: Numbers to add. (First!)
- 2. Crit Range 1: First check (Regions).
- 3. Criteria 1: "East".
-- Select a scenario...
...
⚠️ Common Pitfalls
🚫 Argument Order Flip
In SUMIF, the numbers to add are LAST.
In SUMIFS, the numbers to add are FIRST.
This inconsistency confuses everyone!
🚫 Text Criteria
Criteria like "East" must be in quotes. Criteria like >100 must also be in quotes: ">100".