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

From The Document Foundation Wiki
Jump to: navigation, search

Option – required argument. An option index or reference to a cell with value from 0 to 7 determines what to ignore in the range for the function.

Option index Option applied
0 Ignore only nested SUBTOTAL and AGGREGATE functions
1 Ignore only hidden rows, nested SUBTOTAL and AGGREGATE functions
2 Ignore only errors, nested SUBTOTAL and AGGREGATE functions
3 Ignore hidden rows, errors, nested SUBTOTAL and AGGREGATE functions
4 Ignore nothing
5 Ignore only hidden rows
6 Ignore only errors
7 Ignore only hidden rows and errors