Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
COUNT, COUNTA and COUNTBLANK. COUNT counts cells that hold numbers, and dates are numbers too. COUNTA counts every cell that isn’t empty, text included. COUNTBLANK counts the empty ones. Pick the one that matches what the column holds.
=COUNTBLANK(C2:C40) invoices with no paid date yet
It is the last day of the year. The warehouse lead wants to know how many of the final week’s shipments have arrived and how many are still on the road.
In G1, count all shipments in the list. In G2, count those with a delivered date (column D). In G3, count those still waiting, where column D is empty. Use rows 2 to 18.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Carrier | Shipped | Delivered | Shipments | |||
| 2 | 51080 | Rapid Freight | 2025-12-26 | 2025-12-30 | Delivered | |||
| 3 | 51081 | Rapid Freight | 2025-12-26 | 2025-12-27 | Not delivered yet | |||
| 4 | 51084 | Rapid Freight | 2025-12-26 | 2025-12-31 | ||||
| 5 | 51082 | ParcelLine | 2025-12-27 | 2025-12-29 | ||||
| 6 | 51083 | Greenway Logistics | 2025-12-27 | 2025-12-30 | ||||
| 7 | 51087 | Rapid Freight | 2025-12-27 | 2025-12-29 | ||||
| 8 | 51088 | Rapid Freight | 2025-12-27 | 2025-12-30 | ||||
| 9 | 51086 | ParcelLine | 2025-12-28 | 2025-12-31 | ||||
| 10 | 51089 | ParcelLine | 2025-12-28 | 2025-12-31 | ||||
| 11 | 51091 | Greenway Logistics | 2025-12-29 | 2025-12-31 | ||||
| 12 | 51092 | ParcelLine | 2025-12-29 | |||||
| 13 | 51093 | Greenway Logistics | 2025-12-29 | 2025-12-31 | ||||
| 14 | 51090 | Rapid Freight | 2025-12-30 | 2025-12-31 | ||||
| 15 | 51094 | Greenway Logistics | 2025-12-30 | |||||
| 16 | 51095 | Rapid Freight | 2025-12-30 | 2025-12-31 | ||||
| 17 | 51097 | ParcelLine | 2025-12-31 | |||||
| 18 | 51100 | ParcelLine | 2025-12-31 | |||||
| 19 | ||||||||
| 20 | ||||||||
| 21 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe