Returns the number of blank cells in a list, table or cell range.

rangeThe range of cells from which you want to count the cells.


* This function includes hidden cells.
* This function will only take a range and not an array of numbers.
* Cells with formulas that return "" (empty text) are also counted.
* Cells with zero values are not counted.
* For the Microsoft documentation refer to

1=COUNTBLANK(B1) = 0Text
2=COUNTBLANK(B2:B3) = 1100
3=COUNTBLANK(B1:B3) = 1 
4=COUNTBLANK(B4) = 0""

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