Aggregate

Syntax

Aggregate(Function number, Link1, ...)

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.

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

The following aggregation methods are available:

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

Formula	Result	Description
=Aggregate(103, 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.