Returns the number of empty cells in a given range.
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.
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.