Use the COUNTBLANK function to count cells that are blank. In our example, the formula used is:
(A4:A9) – The cell range from which you want to count the blank cells.
How to count non-empty cells?
Use the COUNTA function to count non-empty cells from a selected range.