COUNTBLANK Function in Excel: Syntax, Examples and Free Practice
COUNTBLANK is an Excel Statistical function. Counts how many cells in a range are empty.
COUNTBLANK syntax
=COUNTBLANK(range)
Arguments
range: The range of cells to check
When to use COUNTBLANK
COUNTBLANK is used in data analysis work to summarize or test patterns across a data set.
Practice COUNTBLANK online, free
Open the live Excel-style spreadsheet and try COUNTBLANK yourself. No Excel install or sign-up needed to start.
Practice COUNTBLANK now →More Statistical functions
Frequently asked questions
What does the COUNTBLANK function do in Excel?
Counts how many cells in a range are empty.
What is the syntax of COUNTBLANK in Excel?
The syntax is =COUNTBLANK(range). range: The range of cells to check.
Where can I practice COUNTBLANK online for free?
Open the free live spreadsheet on Cellgrids and try COUNTBLANK 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