IntermediateData Analysis
Count orders inside a value band
Apply an upper and a lower bound to the same column at once.
COUNTIFS
7 min25 points
Real situations from working spreadsheets — sales targets, commission tiers, messy exports, aged invoices. Numbered in recommended order: start at 1 and work down, or filter to what you need.
1 exercise — Intermediate · Data Analysis · for Product Manager
| # | Exercise | Functions | Difficulty | Time | Status |
|---|---|---|---|---|---|
| 53 | Count orders inside a value bandHarbor Supply — order values, last month | COUNTIFS | Intermediate | 7 min | 25 pts |