SheetsdrillRank without RANK
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
Rank the reps by sales, 1 for the highest. Count how many reps sold more than this one and add 1. Use COUNTIF, and fill C2 and C3 with a formula that could be filled down.
What this exercise teaches
This is what RANK does under the hood, and the same pattern gives you rank within a group by adding a second condition in COUNTIFS. Ties share a rank, as in RANK.
A hint if you get stuck
The criterion is ">"&B2: greater than this row's sales. The range being counted must be locked, the cell being compared must not.
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
- Active SKUs with a prefixPro
- Free shipping rulePro
- Weighted average scorePro