Count Blank/Nonblank Cells

 

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.

CountBlank Function in Excel

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

CountA Function in Excel