Skip to content
Google Sheets

COUNTBLANK function in Google Sheets

Returns the number of empty cells in a given range.

=COUNTBLANK(value1, [value2, ...])

COUNTBLANK syntax and parameters

Two arguments, one required.

  • value1anyRequired
  • value2anyRepeating

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 Excel

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 Google Sheets gets this done.