COUNTIF Function in Excel: Syntax, Examples and Free Practice
COUNTIF is an Excel Statistical function. Counts how many cells in a range match a condition.
COUNTIF syntax
=COUNTIF(range, criteria)
Arguments
range: Cells to checkcriteria: Condition to match, e.g. "Finance"
When to use COUNTIF
Counting how many employees belong to one department.
Practice COUNTIF online, free
Solve graded COUNTIF practice questions in a live Excel-style spreadsheet and check your answer instantly.
Practice COUNTIF now →Watch: COUNTIF in Excel
Learn more
Read the tutorial: How to use COUNTIF.
More Statistical functions
Frequently asked questions
What does the COUNTIF function do in Excel?
Counts how many cells in a range match a condition.
What is the syntax of COUNTIF in Excel?
The syntax is =COUNTIF(range, criteria). range: Cells to check; criteria: Condition to match, e.g. "Finance".
Where can I practice COUNTIF online for free?
Open the free live spreadsheet on Cellgrids and try COUNTIF yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts