Formulas > =COUNTBLANK()
How to Use COUNTBLANK() in Google Sheets
Description
How To Actually Use COUNTBLANK() in Sheets
COUNTBLANK(range)
Try COUNTBLANK yourself
Use the COUNTBLANK formula to count the number of empty cells in the range A1:A10. Your answer should be placed in cell B1.
Hints (2)
-
Remember to specify the range you want to count empty cells in.
-
The result should be a single number representing empty cells.
Better Sheets Tutorial
3 More Ways to Count in Google Sheets
Learn how to use CountBlank() and more counting formulas.
Bjarne Asks: Can I show the total number of rows minus the header row?
find out how to show the total number of data rows available in a sheet.
More related tutorials
Transcript-matched member videos for COUNTBLANK(). Click through to watch.
How to Iterate Counting Blank Cells in Google Sheets
Creating Blank Cells For Good Reasons with IfError Formula and if(isBlank) Formula
Learn more about the COUNTBLANK() formula:
Generate a COUNTBLANK() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses COUNTBLANK(). 2 free AI generations, no signup. Members get unlimited use.
Generate a COUNTBLANK() formula