Statistical Functions
Intermediate
COUNTIF Function
Counting only the rows that broke a rule.
Task:
You promise delivery within 4 days. Put the number of these six deliveries that took longer than that in B8.
Learning Objectives:
- Count against a condition with COUNTIF
- Write a condition as quoted text
- Get an inclusive boundary right
Hints
Solve without hints for +5 XP
The data in this exercise
This is the grid you start with. Cell references in the task — B6, C2 — point at the row numbers and column letters below.
| A | B | |
|---|---|---|
| 1 | Delivery | Days taken |
| 2 | D-2201 | 2 |
| 3 | D-2202 | 5 |
| 4 | D-2203 | 3 |
| 5 | D-2204 | 7 |
| 6 | D-2205 | 4 |
| 7 | D-2206 | 6 |
| 8 | Missed the 4-day promise |
What this exercise teaches (contains the answer)
The boundary is the whole exercise. ">4" counts the 5, 6 and 7-day deliveries; ">=4" would sweep in the one that arrived exactly on the promise and turn a clean record into a breach. Quoting the wrong one of those to a customer is how a report loses its credibility.