Sum, Count & Average

Excel formula for Count blank or non-blank cells

Count how many cells in a range are empty (or filled).

Copy this formula

=COUNTBLANK(A2:A100)

How the formula works

COUNTBLANK counts empty cells, including those with a formula that returns "". For filled cells use COUNTA, and for numbers only use COUNT.

=COUNTA(A2:A100)→63

63 cells contain data.

=COUNTBLANK(B2:B50)→7

Seven cells in B2:B50 are empty.

=COUNTBLANK(A2:A100)/ROWS(A2:A100)→36%

Share of the 99 rows that are still empty, formatted as a percentage.

What's the difference between COUNT and COUNTA?

COUNT counts only numbers; COUNTA counts any non-empty cell, including text.

Does COUNTBLANK count cells that contain a formula returning ""?

Yes. COUNTBLANK counts both truly empty cells and cells whose formula returns an empty string.

Why does COUNTBLANK miss cells that look empty?

They probably contain a space or another invisible character. Count them too with =SUMPRODUCT(--(TRIM(A2:A100)="")).

How do I count blank cells only when another column meets a condition?

Use COUNTIFS with an empty-string criterion: =COUNTIFS(A2:A100, "East", B2:B100, "").

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.