subtotal(int,ConsolidationFunction,int[]) Method | Document Solutions for Excel, Java Edition

Collapse All

In This Topic

subtotal(int,ConsolidationFunction,int[]) Method

In This Topic

Creates subtotals for the range.

Syntax

void subtotal( 
   int groupBy,
   ConsolidationFunction subtotalFunction,
   int[] totalList
)

groupBy: The field to group by, as a one-based integer offset.
subtotalFunction: The subtotal function.
totalList: An array of 1-based field offsets, indicating the fields to which the subtotals are added.