COUNT_TRUE

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

Function syntax

COUNT_TRUE(input1, ...)

Arguments:

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

Examples

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