COUNTBLANK(range)

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.

Remarks

* This function includes hidden rows.
* 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 support.office.com

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


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