COUNTOF function

Prev Next

​​​Description

Counts the number of non-BLANK values of a Block.

Syntax

COUNTOF(Block)

Arguments

Argument

Type

Dimensions

Description

Block

(required)

Any

Any

Returns

Type

Dimensions

Integer

No Dimension

Examples

Employee is a Dimension List:

Formula

Result

Description

COUNTOF(Employee)

4

The Employee List contains 4 items. For a List, all items are counted.

COUNTOF(Employee.Name)

3

The Property Name contains 3 non-BLANK values.

See also

Excel: COUNTA

Related articles: COUNTALLOF, COUNTOF, COUNTBLANKOF

More of a hands-on learner?

Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment!