Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SUMIF. SUMIF adds only the rows that match. It takes three parts: the column to check, what to look for, and the column to add up. Both columns must cover the same rows.
=SUMIF(A2:A20,"Online",D2:D20) adds D only where A says Online
The South sales lead wants to know how much South sold in this batch of June orders.
In F2, add up the values in C2:C11 for the orders whose region is "South".
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Value | Region | Total | |||
| 2 | 50484 | East | 18.05 | South | ||||
| 3 | 50485 | South | 37.2 | |||||
| 4 | 50487 | South | 260.2 | |||||
| 5 | 50488 | East | 129 | |||||
| 6 | 50489 | South | 393 | |||||
| 7 | 50490 | North | 194.82 | |||||
| 8 | 50491 | North | 60 | |||||
| 9 | 50492 | West | 259.75 | |||||
| 10 | 50493 | South | 64 | |||||
| 11 | 50494 | West | 471.9 | |||||
| 12 | ||||||||
| 13 | ||||||||
| 14 |
=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