COUNT_FALSE

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

Function syntax

COUNT_FALSE(input1, ...)

Arguments:

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

Examples

• COUNT_FALSE(A1:A5) - If A1:A5 contains TRUE, FALSE, FALSE, blank, 0, returns 2.
• COUNT_FALSE(in_warranty{}) - Count of FALSE values in the in_warranty field.
• COUNT_FALSE(in_warranty{}, A1:A10) - Count of FALSE values across the in_warranty field and the range A1:A10.
• COUNT_FALSE(in_warranty{region{“APAC”}}) - Count of FALSE values in the in_warranty field where region is APAC.