Roadmap
Day 10 · Formulas 47 min 30 XP
🎯SUMIF, COUNTIF & AVERAGEIF
Conditional functions add, count or average only the rows that match a rule. They answer questions like 'how many units of stickers?' without filtering by hand.
What you'll learn
- Use SUMIF, COUNTIF and AVERAGEIF
- Use SUMIFS for more than one condition
- Write criteria like ">5" and "Pins"
A peek inside
One condition
The rest of Day 10 is a Pro lesson
You're on the free Explorer plan — you get the intro and the video. Go Pro to open the full guided lesson (and all 30 days).
- 3 deep-dive lessons
- A copy-paste worked example
- 3 hands-on practice tasks
- Studio task: Totals without filtering
- 3-question quiz, up to 45 XP
- 3 quick-glance glossary cards
- 30 XP + streak tracking
Already Pro? Sign in