Excel Practice - COUNTIFS
Instruction
Count rows where region in A2:A6 is "South" and value in C2:C6 is greater than 300.
Formula Syntax
=COUNTIFS(criteria_range1, criteria1, ...)
- criteria_range1: Range used to evaluate a condition.
- criteria1: Condition used to filter values.
- ...: Additional optional arguments.
What it does
Count cells that match multiple conditions.
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 COUNTIFS 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.