Count Blank/Nonblank Cells

In this article, you will learn how to count the blank and how to count not blank cells in Excel. In Excel we have functions to count the blank cells and non-blank 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.

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