To work with the tool in Foresight Analytics Platform 10, use the new interface.

Aggregate

The function wizard for the Aggregate function looks as follows:

Syntax

Aggregate(Function number, Link1, ...)

Parameters

Function number. Aggregation method function name.

Link1, Link2, …, LinkN. Aggregated cells range.

Description

It returns result of aggregation with the specified method with a possibility to not take into account hidden values on calculation.

Comments

Available methods and function numbers:

Both values itself or cell addresses or cell ranges containing this values can be specified as aggregated cells.

If the Check References to Empty Cells checkbox is selected, empty values in cells are considered as zero ones.

Example

Formula Result Description
=Aggregate(102, A7:A9) 270 Maximum number in the array stored in A7:A9, without taking into account hidden cells. The A7 cell contains the number 180, A8 (hidden) contains the number 350, A9 contains the number 270.
=Aggregate(4, A4:A10, B4) 1590 The sum of numbers in the A4:A10 array, plus the B4 cell value. Even in case if cells are hidden partially.

See also:

Function WizardMathematical Functions