How to Count Blank or Empty Cells in Google Sheets?

In Google Sheets, you can count the number of blank or empty cells using the COUNTBLANK function. Here’s how you can do it:

1. Open Google Sheets: Open the Google Sheets document where you want to count blank or empty cells.
2. Select a Cell: Choose a cell where you want to display the count result.
3. Enter the Formula: In the selected cell, type the following formula:
   =COUNTBLANK(range)


   Replace range with the actual range of cells you want to count. For example, if you want to count the blank cells in column A from row 1 to 10, the formula would look like:

   =COUNTBLANK(A1:A10)

4. Press Enter: After typing the formula, press the Enter key. The cell will display the count of blank or empty cells in the specified range.

The COUNTBLANK function calculates and returns the count of cells that do not contain any data, including cells that are truly blank or have a formula that returns an empty value.

If you want to count cells that are visually empty but contain a formula that results in a blank text (“”) or empty string, you can use the COUNTIFS function. Here’s how:

1. Enter the Formula: In a cell, type the following formula:
   =COUNTIFS(range, "")


   Replace range with the actual range of cells you want to count.

2. Press Enter: After typing the formula, press the Enter key. The cell will display the count of cells with empty text (“”) in the specified range.

Remember to adjust the formulas based on the specific range you want to count in your Google Sheets document.