Aggregation Functions

Prev Next

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.