Goal: Count how many orders match the criteria.
COUNTIF: One Rule. COUNTIFS: Multiple Rules.
Ready...
💻 Formula Structure
=COUNTIF(range, criteria)
- 1. Range: Where to look (Regions).
- 2. Criteria: What to count ("North").
=COUNTIFS(range1, crit1, [range2, crit2]...)
- 1. Range 1: First check (Regions).
- 2. Crit 1: "North".
- 3. Range 2: Second check (Products).
- 4. Crit 2: "Widget".
-- Select a scenario...
...
⚠️ Common Pitfalls
🚫 Range Size Mismatch
In COUNTIFS, all ranges (Range 1, Range 2) must be the exact same size (e.g., A2:A10 and B2:B10). If they differ, you get a #VALUE! error.
✅ Counting Logic
Use quotes for text ("North") and logic (">100"). Numbers alone don't need quotes (100).