Count(value1, value2, …, valueN)

Returns the number of non-null arguments.

Parameters

value:
The value to check.

Returns

Number

Remarks

For text arguments, non-blanks are counted. For Boolean arguments, "true" values are counted. The exception is the zero value for Numeric arguments; it is counted.

Examples

• Count("", "xyz", "zzz") returns 2
• Count(28, 50, 0) returns 3
• Count(true, false) returns 1
• Count("", 28, "xyz", true, false) returns 3