Input the formula: =COUNTBLANK(Sheet1!1:1048576)
21.13.COUNTBLANK | ||||
21.13.1. | COUNTBLANK counts the number of blank cells within a range | |||
21.13.2. | Return the number of blank cells in column A | |||
21.13.3. | Returns the number of empty cells on the entire worksheet named Sheet1 |