Groups rows based on cell contents and calculates aggregate values.
シンタックス
'宣言
Public Overloads Sub Subtotal( _
ByVal As AggregateEnum, _
ByVal As System.Integer, _
ByVal As System.String, _
ByVal As System.String, _
ByVal As System.String, _
ByVal As System.String _
)
public void Subtotal(
AggregateEnum ,
System.int ,
System.string ,
System.string ,
System.string ,
System.string
)
パラメータ
- aggType
- AggregateEnum value that specifies the type of aggregate to calculate.
- level
- Outline level to assign to the new subtotal rows. This parameter allows the creation of multi-level subtotals and affects the display of the outline tree.
- groupFrom
- Name of the first column in the range used to detect group breaks.
- groupTo
- Name of the last column in the range used to detect group breaks.
- totalOn
- Name of the column that contains values to be aggregated (usually numeric).
- caption
- Text to insert in the subtotal rows.
参照