SheetsdrillActive SKUs with a prefix
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Count the SKUs that start with the prefix in F1 and whose status is "Active". Point at F1 rather than typing the prefix. Answer in F2.
What this exercise teaches
Wildcards work in every *IF and *IFS function. * matches any run of characters and ? matches one, so prefix, suffix and contains checks need no helper column.
A hint if you get stuck
A criterion can be built from a cell and a wildcard: F1&"*" means "starts with whatever is in F1".
Try it now, free, no account needed
The first 15 tasks on Sheetsdrill are free. Open it on the practice page, solve it, and get instant feedback with a hint. A free account adds the worked solution; Pro adds timed mode and the certificate.
Open this exerciseMore exercises in Conditional counting and summing
- Open high-priority ticketsPro
- Sales for one rep and monthPro
- Won deals above a minimumPro
- Average reply timePro
- Largest order in a regionPro
- Cheapest item in stockPro
- Orders between two datesPro
- Customer tiers with IFSPro
- Region names with SWITCHPro
- Contacts on one email domainPro
- Free shipping rulePro
- Weighted average scorePro
- Rank without RANKPro