WorksheetFunction.Subtotal Method (Excel)
Creates subtotals.
Syntax
식 .Subtotal(Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30)
식 A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
필수 |
Double |
A number indicating the aggregation function to be used by the method. |
Arg2 |
필수 |
Range |
The first Range object for which a subtotal is to be calculated. |
Arg3-Arg30 |
선택 |
Variant |
Subsequent Range objects for which a subtotal is to be calculated. |
Return Value
A Double value that represents the subtotal.