Stages
Just playMission 1/5
Show only what you need
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
Filter to one stall
Do thisMission 3/5
Filter, then sort the sales
Do thisMission 4/5
Hide rows, do not delete
Do thisMission 5/5
Total one stall with SUMIF
★★★
Run cleared.
🚀 Push it
- 🟢Filter a long list down to one group.
- 🟡Filter, then clear the filter and check nothing was lost.
- 🔴Explain why filtering does not change a total.
🌐 Make it for real
Open a blank Google Sheet and build the sample narrowed list from an empty grid.
Twist: turn the filter off when you are done and check every row is still there.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- Rows deleted to make a view
- SUM used where the total needs SUMIF
- The filter set on the Item column instead of Stall