Revenue for one region, no helper column
An Excel formula exercise from Formuladrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Revenue is units times price. Put the total revenue of the region named in F1 into F2 with a single SUMPRODUCT, without adding a helper column.
What this exercise teaches
A comparison inside SUMPRODUCT works as a row filter: each row contributes units times price times 1 or 0. SUMIFS cannot do this, because it adds one existing column and cannot multiply two.
A hint if you get stuck
(A2:A7=F1) gives TRUE or FALSE for each row. Multiplying it by the units and the price turns TRUE into 1 and FALSE into 0, so only the matching rows are added.
Try it now, free, no account needed
Your first 15 exercises on Formuladrill 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 exercise, timed mode and the certificate.
Open this exerciseMore exercises in Logic and counting
- Pass or fail
- Letter grades
- Bonus for the north
- Count the shipped orders
- Sales for one region
- Two conditions at once
- Flag for review
- Count with two conditions
- Average for one region
- Scores above a bar
- Best sale in a region
- Shipping tiers
- No more #DIV/0!
- Rank with ties
- Count with a wildcard
- Discount rules
- Average with two conditions
- Sales between two dates
- Plan codes to prices
- How many different customers
- One region or the other
- Everything except one status
- Name a step with LET