Count Blank/Nonblank Cells in Excel

This example shows you how to count the number of blank and nonblank cells in Excel.

1. The COUNTBLANK function counts the number of blank cells.

2. The COUNTA function counts the number of nonblank cells. COUNTA stands for count all.