Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Your manager wants one number for the January sales email.
In B6, calculate total January revenue across all four regions.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Region | Jan | Feb | Mar | ||||
| 2 | North | 7330.02 | 7571.92 | 5449.45 | ||||
| 3 | South | 7903.87 | 8866.97 | 6564.35 | ||||
| 4 | East | 4945.97 | 3585.86 | 5395.82 | ||||
| 5 | West | 9006.93 | 11781.48 | 12500.97 | ||||
| 6 | Total | |||||||
| 7 | ||||||||
| 8 | ||||||||
| 9 |
=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