Skip to content
Excel

COUNTBLANK function in Excel

Counts the number of blank cells within a range

=COUNTBLANK(range)

COUNTBLANK syntax and parameters

One argument, one required.

  • rangerangeRequired

    The range from which you want to count the blank cells.

COUNTBLANK examples

Formulas you'll actually reuse.

  1. How many rows are still missing a ship date:

    =COUNTBLANK(E2:E200)

    Result14

  2. Flag rows with any empty field:

    =IF(COUNTBLANK(A2:F2) > 0, "Incomplete", "OK")

    Result"Incomplete"

COUNTBLANK in Google Sheets

Same name — your formula ports as-is.

Try COUNTBLANK in the playground

Edit the example — nothing to install.

Preloaded with the COUNTBLANK formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Excel gets this done.