Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Ops wants to know how many July orders in this sample were completed in the West.
In F2, count orders where Region is West and Status is completed.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Status | Channel | Completed West orders | |||
| 2 | 50545 | South | completed | Sales Rep | ||||
| 3 | 50546 | South | completed | Sales Rep | ||||
| 4 | 50547 | West | completed | Sales Rep | ||||
| 5 | 50548 | South | completed | Sales Rep | ||||
| 6 | 50549 | South | completed | Partner | ||||
| 7 | 50550 | East | refunded | Sales Rep | ||||
| 8 | 50551 | North | completed | Sales Rep | ||||
| 9 | 50552 | West | completed | Sales Rep | ||||
| 10 | 50553 | North | completed | Online | ||||
| 11 | 50554 | West | completed | Sales Rep | ||||
| 12 | 50555 | North | completed | Online | ||||
| 13 | 50556 | South | completed | Sales Rep | ||||
| 14 | 50557 | South | completed | Partner | ||||
| 15 | 50558 | East | completed | Sales Rep | ||||
| 16 | 50559 | North | completed | Online | ||||
| 17 | 50560 | North | completed | Sales Rep | ||||
| 18 | 50561 | North | completed | Sales Rep | ||||
| 19 | 50562 | South | completed | Partner | ||||
| 20 | 50563 | East | completed | Partner | ||||
| 21 | 50564 | East | completed | Online | ||||
| 22 | ||||||||
| 23 | ||||||||
| 24 |
=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