Excel Practice - SUMIF
Instruction
Sum sales in C2:C6 only for rows where region in A2:A6 equals "North".
Formula Syntax
=SUMIF(range, criteria, [sum_range])
- range: Source range/array for calculation.
- criteria: Condition used to filter values.
- [sum_range]: Range of numbers to sum when criteria are met.
What it does
Sum values that match one condition.
sales-by-region.xlsx
| A | B | C | |
|---|---|---|---|
| 1 | Region | Rep | Sales |
| 2 | North | Liam | 320 |
| 3 | South | Mia | 280 |
| 4 | North | Noah | 410 |
| 5 | West | Olivia | 295 |
| 6 | South | Paul | 360 |
| 7 | Output |
Input Formula
Need Help?
Tips
- Use SUMIF with clean and consistent ranges for predictable results.
- Validate data types (number, text, date) before applying the formula.
- Test the formula with a small sample first, then scale it to larger ranges.