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

SUBTOTAL

Description

Returns a subtotal based on the specified type of calculation and the cells to use. The function doesn't include values from hidden rows (but it does from hidden columns), depending on the aggregation specifier. The function doesn't include values from rows that have been filtered out. A value that's the result of, or includes, a SUBTOTAL() function isn't included in the new SUBTOTAL(). If you specify multiple ranges, then the function includes all values from the ranges in the final aggregation.

Syntax

SUBTOTAL(
function_num
,
ref1
, [
ref2
], ...)
  • function_num
    : The number representing the function to perform.
    Function
    To Include Hidden Values
    To Ignore Hidden Values
    AVERAGE
    1
    101
    COUNT
    2
    102
    COUNTA
    3
    103
    MAX
    4
    104
    MIN
    5
    105
    PRODUCT
    6
    106
    STDEV
    7
    107
    STDEVP
    8
    108
    SUM
    9
    109
    VAR
    10
    110
    VARP
    11
    111
  • ref1
    : A reference to cells containing values for the calculation.
  • ref2
    : A reference to cells containing values for the calculation.

This content is not part of the Workday Administrator Guide.