ModeldrillRoll months into quarters
A financial modeling exercise from Modeldrill. Solve it with a live spreadsheet grid in your browser, with Fill right and Fill down, and it is checked the moment you submit.
The task
Monthly revenue is in row 6, and row 5 labels each month with its quarter. Fill the quarterly totals in row 9 with SUMIF, so each total adds the months whose label matches the quarter in row 8. Write B9 with locked ranges, then fill right to E9.
What this exercise teaches
A label row plus SUMIF turns a monthly model into quarters or years without hard-wired ranges such as B6:D6. Move a month to a different quarter, or change a fiscal year, and only the labels change.
A hint if you get stuck
SUMIF(range to test, criterion, range to add). Lock the label row and the revenue row with dollar signs and leave the quarter in row 8 free to move.
Try it now, free, no account needed
The first 15 tasks on Modeldrill 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 unlocks every task, timed mode and the certificate.
Open this exerciseMore exercises in Model basics
- Grow revenue from one assumption
- Price times volume
- Cost as a share of revenue
- Gross profit and gross margin
- Year over year growth
- One formula for a whole block
- Payroll from headcount and raises
- Twelve months of subscribers
- Revenue mix by product
- Revenue from unit growth and price growth
- CAGR and an index rebased to 100
- Price from a target margin