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!
