Exercises / Conditional counting and sums · 1 of 11
Count the late deliveries
COUNTIF(range, criteria) counts the cells in a range that meet one condition. Text criteria go in quotes and ignore case.
Your taskIn F2, use COUNTIF to count how many deliveries in C2:C11 have the status "Late".
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Shipment | Carrier | Status | Measure | Value | |
| 2 | SH-301 | FastShip | On time | Late | ||
| 3 | SH-302 | Nordline | Late | |||
| 4 | SH-303 | FastShip | On time | |||
| 5 | SH-304 | Parcelo | Late | |||
| 6 | SH-305 | Nordline | On time | |||
| 7 | SH-306 | Parcelo | On time | |||
| 8 | SH-307 | FastShip | Late | |||
| 9 | SH-308 | Nordline | On time | |||
| 10 | SH-309 | Parcelo | On time | |||
| 11 | SH-310 | FastShip | On time |