Drill SUMIF, SUMIFS, wildcards, date ranges and cross-tab references on a mock workbook.
Level 1 · SUMIF basics
Sheets: Sales · You're on Sales
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Product | Units | Amount |
| 2 | Ana | West | Widget A | 10 | 500.00 |
| 3 | Ben | East | Widget B | 5 | 300.00 |
| 4 | Cid | West | Gadget X | 8 | 640.00 |
| 5 | Dan | South | Widget A | 12 | 600.00 |
| 6 | Eve | East | Widget A | 7 | 350.00 |
| 7 | Fay | West | Gadget X | 3 | 240.00 |
| 8 | Gil | North | Widget B | 9 | 540.00 |
| 9 | Hal | South | Gadget X | 6 | 480.00 |
| 10 | Ivy | East | Widget B | 4 | 200.00 |
| 11 | Jon | West | Widget A | 11 | 550.00 |