To count the number of blank cells, you can use the COUNTIF function or the COUNTBLANK function.
1. COUNTIF Function
= COUNTIF(Range, "")
– The range is required, which will be the range of cells that you want to count;
– Blank "" is required.
There is no space in the quotation mark (""), otherwise, you will get errors.
Example 1: To count how many blank cells in column A.
– Range: Column A (A2:A8)
– Blank "" (criteria): quotation mark "".
There is 2 blank cells in column A.
2. COUNTBLANK Function
You can also use the COUNTBLANK function to count blank cells.
Example 2: To count blank cells in column A
There are 2 blank cells in column A.