Aggregate

The function wizard for the Aggregate function looks as follows:

Syntax

Aggregate(Function number, Link1, ...)

Parameters

Function number. Function number of aggregation method, available function numbers:

• Average. 1 is to take into account hidden values, 101 is to ignore hidden values.

• Max. 2 is to take into account hidden values, 102 is to ignore hidden values.

• Min. 3 is to take into account hidden values, 103 is to ignore hidden values.

• Sum. 4 is to take into account hidden values, 104 is to ignore hidden values.

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

NOTE. Both value itself or address of the cell (cell range) containing this value can be specified as the parameter.

Description

Returns result of aggregation with selected method with a possibility to not taking into account hidden values on calculation. Available methods:

• Average;

• Max;

• Min;

• Sum.

Comments

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

Example

See also:

Function Wizard │ Mathematical