---
title: "Aggregation Functions"
slug: "aggregation-functions"
description: "The functions described in this section help users count Items under specific conditions, and find highest, lowest and other values within your Blocks."
updated: 2026-01-20T11:59:13Z
published: 2026-01-20T11:59:13Z
canonical: "kb.pigment.com/aggregation-functions"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Aggregation Functions

The functions in this section help you count Items under specific conditions, and find highest, lowest and other values within your Blocks.

Use COUNTOF, COUNTALLOF, COUNTBLANKOF and COUNTUNIQUEOF to perform counts of different kinds of Items. SUMOF, AVGOF, MINOF and MAXOF return sums, averages and highest and lowest Items.