> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# ArrayLength

> Use the Sigma ArrayLength function to return the number of entries in a list.

The **ArrayLength** function returns the number of entries in a list.

## Syntax

```
ArrayLength(array)
```

The **ArrayLength** function has the following argument:

<dl>
  <dt>
    array
  </dt>

  <dd>
    Required
  </dd>

  <dd>
    Sigma counts the number of entries in this list
  </dd>

  <dd>
    Must reference a list parameter, or a column that contains list values
  </dd>
</dl>

## Example

A table contains a *Products Bought* column that has list values. You can use the **ArrayLength** function to count the number of products in the list of values.

```
ArrayLength([Products Bought])
```

![](https://files.buildwithfern.com/sigma.docs.buildwithfern.com/4a1b5235c031e389f0878613b2db6e1fc5a47d8a4112c6b3d840b5eab461efe4/assets/docs-images/dd0face-Screenshot_2023-03-06_at_6.17.23_PM.png)

## Related resources

* [ArrayContains](/docs/arraycontains)
* [ArrayDistinct](/docs/arraydistinct)
* [ArraySlice](/docs/arrayslice)