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.

What's the difference between COUNT and COUNTA?

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

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.