Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
AGGREGATE

AGGREGATE

Description

Runs the aggregation evaluation that you specify. Optionally, you can ignore certain types of values. This function is intended for use on columns of data (vertical ranges), not rows of data.

Syntax

AGGREGATE(
function_num
, [
options
],
ref1
, [
ref2
])
  • function_num
    : A number from 1 to 19 that specifies the aggregation function.
    Number
    Function
    1
    AVERAGE
    2
    COUNT
    3
    COUNTA
    4
    MAX
    5
    MIN
    6
    PRODUCT
    7
    STDEV.S
    8
    STDEV.P
    9
    SUM
    11
    VAR.P
    12
    MEDIAN
    13
    MODE.SNGL
    14
    LARGE
    15
    SMALL
    16
    PERCENTILE.INC
    17
    QUARTILE.INC
    18
    PERCENTILE.EXC
    19
    QUARTILE.EXC
  • options
    : A number from 0-7 that specifies which values in the range to ignore. If you omit the argument, the function uses 0.
    Number
    Action
    0
    Ignore nested SUBTOTAL and AGGREGATE functions
    1
    Ignore hidden rows, nested SUBTOTAL and AGGREGATE functions
    2
    Ignore error values, nested SUBTOTAL and AGGREGATE functions
    3
    Ignore hidden rows, error values, nested SUBTOTAL and AGGREGATE functions
    4
    Ignore nothing
    5
    Ignore hidden rows
    6
    Ignore error values
    7
    Ignore hidden rows and error values
  • ref1
    : The first argument; it can be a number, array, an array formula, or a reference to a range of cells.
  • ref2
    : One or more additional arguments. These functions require a ref2 argument: LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC.

Notes

If the array argument includes a calculation, the function won't ignore hidden rows, nested subtotals, or nested aggregates.

This content is not part of the Workday Administrator Guide.