COUNT_NOT_BLANK

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

Function syntax

COUNT_NOT_BLANK(input1, ...)

Arguments:

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

Examples

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