COUNTIF Function| COUNTBLANK Function
To count the number of blank cells, you can use the COUNTIF function or the COUNTBLANK function.
1. COUNTIF Function
Formula:
= COUNTIF(Range, "")
Explanations:
– The range is required, which will be the range of cells that you want to count;
– Blank "" is required.
Cautions:
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 "".
= COUNTIF(A2:A8,"")
There is 2 blank cells in column A.
2. COUNTBLANK Function
You can also use the COUNTBLANK function to count blank cells.
Formula:
=COUNTBLANK(Range)
Example 2: To count blank cells in column A
=COUNTBLANK(A2:A8)
There are 2 blank cells in column A.