Expression Language Reference
    Preparing search index...
    • Returns a subtotal in a list or database.

      Category: Math and trigonometry

      Parameters

      • function_num: any

        The number 1-11 or 101-111 that specifies the function to use for the subtotal. 1-11 includes manually-hidden rows, while 101-111 excludes them; filtered-out values are always excluded.

      • ref1: any

        The first named range or reference for which you want the subtotal.

      Returns any