COUNT_IF

Counts the number of TRUE input values.

This function is equivalent to COUNT(CASE WHEN X THEN 1 END).

Syntax

COUNT_IF(X)

Type: any

Values that be evaluated as a Boolean.

Type: bigint

Returns the number of TRUE input values.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!