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.
2 Better Sheets Tutorials
3 More Ways to Count in Google Sheets
Learn how to use CountBlank() and more counting formulas.
COUNTBLANK()
COUNTIFS()
COUNTUNIQUE()
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.
COUNTA()
COUNTBLANK()
SUM()
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