Translations:Documentation/Calc Functions/AGGREGATE/15/en

From The Document Foundation Wiki
Jump to: navigation, search

Function – required argument. A function index or a reference to a cell with value from 1 to 19, in accordance with the following table.

Function index Function applied
1 AVERAGE
2 COUNT
3 COUNTA
4 MAX
5 MIN
6 PRODUCT
7 STDEV.S
8 STDEV.P
9 SUM
10 VAR.S
11 VAR.P
12 MEDIAN
13 MODE.SNGL
14 LARGE
15 SMALL
16 PERCENTILE.INC
17 QUARTILE.INC
18 PERCENTILE.EXC
19 QUARTILE.EXC