Last Updated on September 6, 2023 by Jake Sheridan
In this tutorial, you will learn how to count blank or empty cells in Google Sheets.
How to Count Blank or Empty Cells in Google Sheets
If you’re looking to get an overview of your data, you may need to count the number of blank or empty cells in a certain range. For example, say you have a list of names and you want to know how many entries are missing.
Fortunately, Google Sheets makes it easy to count the number of blank or empty cells in a range. In this guide, we will show you how to count blank or empty cells in Google Sheets. We’ll explain how to use both the COUNTBLANK function and the COUNTIF function to find the number of empty cells in a given range.
How to Determine the Number of Empty Cells in Google Sheets
Here’s our step-by-step guide on how to determine the number of empty cells in Google Sheets.
First, select the cell where you want to add the formula to count empty cells. In this example, we’ll add our formula in cell G3.
Type the COUNTBLANK formula into the selected cell.
Enter the range you want to count blank in as an argument for the COUNTBLANK function.
In the example above, we’ve found 6 empty cells in the range C2:C24.
We can also use the COUNTIF function to find empty cells.
Simply enter the range you want to count as the first argument and add an empty string as the second argument. This will make sure that the formula only counts cells that contain an empty string.
This guide should be everything you need to learn how to count blank or empty cells in Google Sheets.
Click this link to make a copy of this sample document to try doing it yourself!