Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
COUNTIF. COUNTIF(range, what to count) counts the cells in a range that match. Text criteria go in double quotes.
=COUNTIF(C2:C20,"West") counts the cells that say West
Ops wants to know how many of yesterday’s ten orders were completed.
In E2, count the orders in B2:B11 with status "completed".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Status | ||||||
| 2 | 50201 | completed | Completed | |||||
| 3 | 50202 | completed | ||||||
| 4 | 50203 | refunded | ||||||
| 5 | 50204 | completed | ||||||
| 6 | 50205 | cancelled | ||||||
| 7 | 50206 | completed | ||||||
| 8 | 50207 | completed | ||||||
| 9 | 50208 | refunded | ||||||
| 10 | 50209 | completed | ||||||
| 11 | 50210 | completed | ||||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=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