Excel Practice - COUNTIF
Instruction
Count how many cells in A2:A6 are equal to "North".
Formula Syntax
=COUNTIF(range, criteria)
- range: Source range/array for calculation.
- criteria: Condition used to filter values.
What it does
Count cells 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 COUNTIF 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.