Skip to main content

COUNT

Use the COUNT function to count the number of items in a Text, Number or Choice array that are numbers. Numbers are actual numbers, like 12 or 102 or text that contains only numbers, such as "123" or "99.99".

Use

COUNT( array )
Counts how many numbers are in the array.

ParameterRequiredDescription
arrayYesa text, number or choice array

ReturnsNumber

Use with literals

COUNT({1, 2, 3})

returns 3

COUNT({"1", "2", "hello"})

returns 2

Use with fields

COUNT(@inp.ClaimAmounts)

if input field @inp.ClaimAmounts contains 4 items but one is blank, returns 3