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

CodeFunctionName What is this?

Public

Tested

Original Work

Access is limited.

Login here using your Linkedin account. to see or download code.

No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Boldcodes.com

Linkedin Login

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

Views 250

Downloads 89

CodeID
DB ID