# Collection macros

Discover the available macros to work with collections in CQL.

> **Looking for something specific?**
>
> Use the search bar at the top of the page or press `/` to quickly search through the documentation.

Use the summary below to quickly jump to a specific topic:

- [Count macro](/reference/cql/expressions/macros/collection/count): Learn how to count items in a collection.
- [Minimum macro](/reference/cql/expressions/macros/collection/minimum): Learn how to find the smallest number in a collection.
- [Maximum macro](/reference/cql/expressions/macros/collection/maximum): Learn how to find the largest number in a collection.
- [Sum macro](/reference/cql/expressions/macros/collection/sum): Learn how to calculate the sum of a collection of numbers.
- [Average macro](/reference/cql/expressions/macros/collection/average): Learn how to calculate the average of a collection of numbers.
- [First-element macro](/reference/cql/expressions/macros/collection/first-element): Learn how to get the first element of a collection.
- [Last-element macro](/reference/cql/expressions/macros/collection/last-element): Learn how to get the last element of a collection.
- [Keys macro](/reference/cql/expressions/macros/collection/keys): Learn how to get the keys of a collection.
- [Sublist macro](/reference/cql/expressions/macros/collection/sublist): Learn how to select a range of elements from a collection.