- range – The range in which to count blank cells.
Use the COUNTBLANK function to count blank cells in a range. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10.
COUNTBLANK counts the number of cells in the range that don’t contain any value and returns this number as the result. Cells that contain, text, numbers, errors, etc. are not counted.
Cells that contain formulas that return empty text (“”) are considered blank and will be counted.
Cells that contain zero are considered not blank and will not be counted.