COUNTBLANK

Returns the number of empty cells in a given range.

COUNTBLANK for BigQuery

Returns the number of empty values in a data column.

Sample usage

COUNTBLANK(table_name!fruits)

Syntax

COUNTBLANK(column)

  • column: The data column in which to count the number of nulls.
Tip: Counting blanks in multiple columns is not supported.

Sample usage

COUNTBLANK(A2:C100)

Syntax

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

  • value1 – The first value or range in which the number of blanks is counted.
  • value2 – [OPTIONAL ] – Additional values or ranges in which the number of blanks is counted.

Notes

  • COUNTBLANK considers cells with no content and cells containing an empty string ("") to be blank cells.

See also

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numerical values selected from a database table-like array or range using an SQL-like query.

COUNTUNIQUE: Counts the number of unique values in a list of specified values and ranges.

COUNTIF: Returns a conditional count across a range.

COUNTA: Returns the number of values in a dataset.

COUNT: Returns the number of numeric values in a dataset.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu