Course
COUNTIF practice exercises
Ten exercises, from your first COUNTIF to wildcards, blank cells, criteria built from cells and duplicate checks. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 10
Count orders with a given status
In F2, use COUNTIF to count how many orders in C2:C9 have the status Delivered.
| Order no. | Sales rep | Status | Amount ($) | Delivered orders | |
| C-2401 | Olivia | Delivered | 320.00 | ||
| C-2402 | James | Pending | 780.00 | ||
| C-2403 | Olivia | Delivered | 145.00 | ||
| C-2404 | Sofia | Cancelled | 1,250.00 | ||
| C-2405 | James | Delivered | 560.00 | ||
| C-2406 | Olivia | Pending | 90.00 | ||
| C-2407 | Sofia | Delivered | 430.00 | ||
| C-2408 | James | Cancelled | 615.00 |