COUNTIF practice
COUNTIF counts the cells in a range that meet one condition. Below are the 1 Google Sheets exercise on Sheetsdrill that use it, each checked instantly in your browser.
Syntax
COUNTIF(range, criterion)
What people get wrong
Criteria are text, so a comparison is written in quotes: ">=100", or joined to a cell: ">="&B1.
Google Sheets exercise that use COUNTIF
- Contacts on one email domainLevel 2Pro
Practice COUNTIF now
The free exercises work without an account. Pro unlocks every exercise, with worked solutions and progress saved to your account.
Start practicing free