Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using INDIRECT function method
Passing column name, and list of rows separated by certain char, the function will return SUM (or others) of that group of cells
Needed when you need to have list of rows variable, meaning you do not always use the same rows to get their SUM (or others)
Uses same Function_Num as in SUBTOTAL Excel function
    ' Function_Num Ignore hidden
    ' 1        101        AVERAGE
    ' 2        102        COUNT
    ' 3        103        COUNTA
    ' 4        104        MAX
    ' 5        105        MIN
    ' 6        106        PRODUCT
    ' 7        107        STDEV
    ' 8        108        STDEVP
    ' 9        109        SUM
    ' 10    110        VAR
    ' 11    111        VARP


Public

Tested

My Own Work

Function_Num, ColumnName, List_of_Rows, Optional Sepa = "|", Optional Shee = "Active", Optional WB = "This"

Views 1 Downloads 0