Counts the number of empty cells in a specified range of cells.
Sintaxis
COUNTBLANK(range)Argumentos
rangeobligatorio
The range of cells from which you want to count the blank cells.
The COUNTBLANK function identifies cells that contain no data, including cells that appear empty but contain formulas returning an empty string. It is commonly used to audit datasets for missing values or incomplete entries.
=COUNTBLANK(A1:A5)→2If cells A1, A3, and A5 contain data, and A2 and A4 are empty, the result is 2.
Select the target cell
Click on the cell where you want the result to appear.
Enter the formula
Type =COUNTBLANK( and highlight the range of cells you wish to evaluate, then close the parenthesis.
No, cells containing a space are considered non-blank and are not counted.