Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SUMIFS: two conditions. SUMIFS adds the rows that match every condition. Careful: the column to add comes first, then pairs of (column to check, what to look for). Add as many pairs as you need.
=SUMIFS(E2:E50,A2:A50,"Online",B2:B50,"SMB") Online AND SMB
Revenue at Brightline counts completed orders only. Finance wants West’s revenue from this batch of April orders.
In F2, add up the values in D2:D13 where Region is "West" and Status is "completed".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Status | Value | West revenue | |||
| 2 | 50269 | West | completed | 99 | ||||
| 3 | 50270 | South | completed | 57 | ||||
| 4 | 50271 | North | completed | 45.6 | ||||
| 5 | 50272 | North | refunded | 84 | ||||
| 6 | 50273 | North | completed | 249.62 | ||||
| 7 | 50274 | South | completed | 1167.9 | ||||
| 8 | 50275 | South | completed | 104.31 | ||||
| 9 | 50276 | West | completed | 108 | ||||
| 10 | 50277 | South | completed | 144 | ||||
| 11 | 50278 | South | completed | 120.57 | ||||
| 12 | 50279 | North | completed | 247.61 | ||||
| 13 | 50280 | West | cancelled | 287.98 | ||||
| 14 | ||||||||
| 15 | ||||||||
| 16 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe