COUNTA

Use the COUNTA function to get the number of items in any type of array that are not blank.

Use

COUNTA( array )
Counts the non-blank items in array.

Parameter	Required	Description
array	Yes	an array of any type

Returns

Number

Use with literals

COUNTA({1, 2, 3, BLANK})

returns 3

COUNTA({"a", "b", "1", "2", "", BLANK})

returns 4

COUNTA({DATE(2024,1,1), BLANK})

returns 1

COUNTA({TRUE, FALSE, BLANK})

returns 2

Use with fields

COUNTA(@Review.out.Notes)

if field @Review.out.Notes contains 4 items but one is blank, returns 3