Skip to content
Adaptam Docs

COUNT_BLANK

Count of blank values in cells, ranges, or data fields.

COUNT_BLANK function overview

Function syntax

COUNT_BLANK(input1, ...)

Arguments:

  • input1, …: One or more values, cells, ranges, or data fields.

Examples

  • COUNT_BLANK(A1:A5) - If A1:A5 contains 10, (empty cell), hello, (empty cell), 5, returns 2.
  • COUNT_BLANK(sales{}) - Count of blank values in the sales field.
  • COUNT_BLANK(sales{}, A1:A10) - Count of blank values across the sales field and the range A1:A10.
  • COUNT_BLANK(sales{region{“EMEA”}}) - Count of blank values in the sales field where region is EMEA.