Task 1 of 3
Turn on the filter and keep only the Chicago deals visible.
Lesson theory
A filter temporarily hides the rows that do not match a condition. Your data is not deleted.
- click any cell in the table and click Filter on the toolbar;
- ▾ buttons appear in the headers: click the one on the column you need;
- select the values you want, or set a condition ("greater than", "contains").
The ordinary SUM adds up hidden rows too. SUBTOTAL(9, range) adds up only the visible ones
(9 is sum, 1 is average, 2 is count of numbers, 4 is maximum).
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page