COUNTBLANK

COUNTBLANK(range)

Returns the number of empty cells.

rangeThe 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 non blank cells in a list, table or cell range.
* 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 AGGREGATE function to exclude hidden cells.
* You can use the COUNTAVISIBLE - User Defined Function to exclude hidden cells.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

 AB
1=COUNTBLANK(B1) = 05
2=COUNTBLANK(B1:B2) = 010
3=COUNTBLANK(B3) = 1=""
4=COUNTBLANK(B4) = 1 
5=COUNTBLANK(B5) = 00
6=COUNTBLANK(B6) = 0text
7=COUNTBLANK(B7) = 0TRUE
8=COUNTBLANK(B8) = 0FALSE
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".

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top