Spread.NET 17 Formula Reference
Formula Functions / Functions R to S / SUBTOTAL
In This Topic
    In This Topic

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





    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.


    The SUBTOTAL function does not include other SUBTOTAL formula results that are in the same range.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.



    Version Available

    This function is available in product version 2.0 or later.

    See Also

    SUMPRODUCT | SUM | Math and Trigonometry Functions