Pro lesson · 5 exercises · first one free
Counting by condition: COUNTIF and COUNTIFS
Count rows that match one or several conditions, including partial text.
Functions you'll practice
How the lesson works
5 short exercises in a live spreadsheet: you type each formula yourself. Every answer is checked instantly, with hints when you're stuck.
The lesson starts with
COUNTIF(range, criteria) counts the cells in a range that match the criteria.Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.