How to count blank or empty cells in Excel and Google Sheets

Microsoft Excel and Google Sheets support countless functions so that users can perform various jobs. There are certain functions called COUNTBLANK, COUNTIF, SUMPRODUCT, etc. that will help you count empty or empty cells. Sometimes you may need to count all of the blank cells in a worksheet. If it has two or three columns and ten or twenty rows, you can calculate them manually. However, the problem begins when you are going to count the empty cell of a large worksheet. This is when you can use this tip to get the exact number of blank cells in Google Sheets or Excel.

Count empty or empty cells in Excel or Google Sheets

To count empty or empty cells in Google Sheets and Excel, follow these steps:

1. Open the spreadsheet in Google Sheets or Excel.
2. Use the COUNTBLANK, COUNTIF or SUMPRODUCT function

First, you need to open the spreadsheet in Google Sheets or Microsoft Excel. Now you need to write down the columns / rows for which you want to find the number of blank cells. It can be one or more columns and it depends on your needs.

After that click on an empty cell in your spreadsheet where you want to display the number. Then enter a function like this-

=COUNTBLANK(A2:D5)

This COUNTBLANK The function counts empty cells between A2 and D5. You can change the column / row number as needed.

There is another function that does the same job as COUNTBLANK. It is called COUNTIF. This is useful when users need to count cells containing a specific word, number, or symbol. However, you can use the same function to count empty cells in Google Sheets as well as the Microsoft Excel spreadsheet.

To use this method, you need to open a spreadsheet, select a cell and enter this function-

=COUNTIF(A2:D5,"")

You must modify the range according to your needs. The COUNTIF function requires a value between reverse commas. As you will find empty cells, there is no need to enter any value or text.

The third function is SUMMARY. Although it is quite different from the other functions due to its characteristics, you will get the job using the SUMPRODUCT function.

As usual, you have to select a cell where you want to display the number and enter this function-

=SUMPRODUCT(--(A2:D5=""))

You must change the range before accessing this function and do not write anything between reverse commas.

I hope this tutorial will help you.