Formuladrill

Level 2: Logic and counting Exercise 35 of 118

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.

Functions used: SUMPRODUCT

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 exercise

More exercises in Logic and counting