COUNTBLANK

COUNTBLANK(range)

Returns the number of empty cells.

range

The range of cells you want to count.

REMARKS

* This function includes hidden cells.
* This function will only take a single range.
* This function cannot be used with more than one cell reference.
* Cells containing formulas that return "" (empty text) are included. See Example 3.
* Cells containing zeros are excluded. See Example 5.
* You can use the COUNT function to return the number of numerical values.
* You can use the COUNTA function to include logical values, text and errors.
* You can use the COUNTIFS function to return the number of non blank cells that satisfies multiple conditions.
* You can use the COUNTAVISIBLE - User Defined Function to exclude hidden cells.
* You can use the AGGREGATE function to exclude hidden cells.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B
1	=COUNTBLANK(B1) = 0	5
2	=COUNTBLANK(B1:B2) = 0	10
3	=COUNTBLANK(B3) = 1	=""
4	=COUNTBLANK(B4) = 1
5	=COUNTBLANK(B5) = 0	0
6	=COUNTBLANK(B6) = 0	text
7	=COUNTBLANK(B7) = 0	TRUE
8	=COUNTBLANK(B8) = 0	FALSE
9	=COUNTBLANK(B9) = 0	=DATE(2024, 1, 1) = 01 Jan 2024
10	=COUNTBLANK(B10) = 0	=10/0 = #DIV/0!

1 - How many cells are blank in the range "B1".
2 - How many cells are blank in the range "B1:B2".
3 - Formulas containing empty strings are included. "B3".
4 - Cells that are empty are included. "B4".
5 - Cells that contain zero are excluded. "B5".
6 - Cells that contain text are excluded. "B6".
7 - Cells that contain logical values are excluded. "B7".
8 - Cells that contain logical values are excluded. "B8".
9 - Cells that contain dates are excluded. "B9".
10 - Cells that contain error values are excluded. "B10".