Stages
Just playMission 1/5
Count only what matches
Nothing is scored here. Press things and see what changes.
Do thisMission 2/5
Count passes with COUNTIF
Do thisMission 3/5
Count the exact edge too
Do thisMission 4/5
Put the test in quotes
Do thisMission 5/5
Reach every row, skip header
★★★
Run cleared.
🚀 Push it
- 🟢Count how many students scored over 80.
- 🟡Count two different things on one sheet.
- 🔴Explain the quotation marks around the test.
🌐 Make it for real
Open a blank Google Sheet and build the sample pass count sheet from an empty grid.
Twist: change one mark and one day count when you are done, and watch each count follow.
🧑🏫 Teacher Guideclick to open
⏱ 52218
✅ Watch for
- COUNT used where COUNTIF was needed
- "More than" used where the label says "or more"
- Tests typed without quotation marks