SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / SUBTOTAL
In This Topic
    SUBTOTAL
    In This Topic

    This function calculates a subtotal of a list of numbers using a specified built-in function.

    Syntax

    SUBTOTAL(functioncode,value1,value2,...)

    SUBTOTAL(functioncode,array)

    Arguments

    The functioncode argument is the number that represents the built-in function to use for the subtotal, as given in this table.

    Built-In Function Function Code (Include Hidden Values) Function Code (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

    Each additional argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments can be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

    Remarks

    The SUBTOTAL function does not include other SUBTOTAL formula results that are in the same range. Setting the row height to zero also hides the values.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    SUBTOTAL(8,A1:B7)

    See Also