Stages
Just playMission 1/5
Total one group only
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
Add one stall with SUMIF
Do thisMission 3/5
Average one stall with AVERAGEIF
Do thisMission 4/5
Line up both ranges
Do thisMission 5/5
Read the stall from a cell
★★★
Run cleared.
🚀 Push it
- 🟢Report the South stall the same way.
- 🟡Total one item across both stalls.
- 🔴Explain what happens if the ranges are different sizes.
🌐 Make it for real
Open a blank Google Sheet and build the sample stall report from an empty grid.
Twist: change one sale when you are done and watch every total follow.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- SUM used where SUMIF was needed
- Test range and sum range of different heights
- Stall names typed slightly differently