Returns the count of the number of empty cells.
- range: A range of cells from which you want to count blank cells.
- If there is a zero in a cell, it will be considered as a non-blank cell, hence ignored.
- If a cell has a formula resulting in an empty (=” “), that will also consider as a non-blank cell.
- Cells contain numbers, text, errors, and symbols will be ignored.
Written by Puneet for Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel for Mac