Exercises / Conditional counting and sums · 11 of 11
Revenue for one region, no helper column
A comparison like (A2:A6="Yes") gives TRUE or FALSE for each row. Multiplying turns TRUE into 1 and FALSE into 0, so the rows that fail the test count as 0: =SUMPRODUCT((A2:A6="Yes")*B2:B6) adds column B only where column A says Yes.
Your taskIn H2, work out the revenue (price × quantity) for the region in H1 only, using SUMPRODUCT.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F | G | H |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Price | Qty | Region | North | ||
| 2 | #01 | North | $24.00 | 10 | Revenue | |||
| 3 | #02 | South | $18.00 | 25 | ||||
| 4 | #03 | North | $32.00 | 6 | ||||
| 5 | #04 | East | $24.00 | 12 | ||||
| 6 | #05 | South | $40.00 | 3 | ||||
| 7 | #06 | North | $18.00 | 14 | ||||
| 8 | #07 | East | $32.00 | 8 | ||||
| 9 | #08 | North | $40.00 | 5 | ||||
| 10 | #09 | South | $24.00 | 9 |