Count Blank/Nonblank Cells in Excel
This example shows you how to count blank and nonblank cells in Excel.
1. The COUNTBLANK function below counts the number of blank cells in the range A1:A7.
2. The COUNTA function below counts the number of nonblank cells in the range A1:A7. COUNTA stands for count all.
3. The COUNTIFS function below counts the number of blank cells in the range B1:B7 with one additional criteria (blue).
Explanation: the COUNTIFS function (with the letter S at the end) in Excel counts cells based on two or more criteria. Use an empty string (two double quotes with nothing in between) to find blank cells.
4. The COUNTIFS function below counts the number of nonblank cells in the range B1:B7 with one additional criteria (pink).
Written by
Jason Howie
Founder, FormulasHQ
A formula nerd with a passion for numbers and equations. Writes about Excel, Google Sheets, VBA, regex, and Salesforce formulas — for people who spend their day in spreadsheets.