Question EN

How do I count blank cells in Excel?

Answer

The COUNTBLANK function counts empty cells in a range. For example, =COUNTBLANK(A1:A100) shows how many cells are unfilled.

Detailed explanation

Excel has a dedicated function for counting blank cells.

The COUNTBLANK Function

=COUNTBLANK(A1:A100)

Returns the number of empty cells in the specified range.

The Reverse — Non-Empty Cells

The COUNTA function counts filled cells:

=COUNTA(A1:A100)

Alternative Using COUNTIF

=COUNTIF(A1:A100, "")

Also counts blanks, but COUNTBLANK is shorter.

Things to Note

A cell with a formula returning "" — counts as blank for COUNTBLANK
A cell with a space — is NOT considered blank
A cell with zero — is NOT blank

Fill Rate Percentage

=COUNTA(A1:A100)/COUNT(A1:A100)*100

Or simpler:

=1-COUNTBLANK(A1:A100)/100

02.02.2026 Excel / Google Sheets

Need a custom formula?

Describe your task — AI will generate a working formula in seconds

Generate Formula

Related Questions

How do I calculate a percentage in Excel?

Multiply the number by the percentage and divide by 100. For example, =A1*15/100 or simply =A1*15% — Excel understands both.

How do I round numbers in Excel?

Use the ROUND function: ROUND(number, decimals). For example, =ROUND(3.14159, 2) returns 3.14. For rounding up use ROUNDUP, for down use ROUNDDOWN.

How do I calculate an average in Excel?

The AVERAGE function calculates the arithmetic mean. For example, =AVERAGE(A1:A10) computes the average of a 10-cell range.

How do I raise a number to a power in Excel?

Use the ^ operator or the POWER function. For example, =2^3 or =POWER(2,3) — both return 8 (two cubed).

How do I get the absolute value in Excel?

The ABS function returns the absolute value of a number. For example, =ABS(-15) returns 15, and =ABS(15) also returns 15.

Great formula!

Sign in to save formulas and get more free requests

Sign in for free