SUBTOTAL.CREATE

Equivalent to choosing the Subtotals command from the Data menu. Generates a subtotal in a list or database.

Syntax

SUBTOTAL.CREATE(at_change_in, function_num, total, replace, pagebreaks, summary_below)
SUBTOTAL.CREATE?(at_change_in, function_num, total, replace, pagebreaks, summary_below)

At_change_in is a column offset corresponding to the At Each Change In text box on the Subtotal dialog box.

Function_Num is a number corresponding to the Use Function list box specifying which function you want to use in subtotaling your data.

Function Function_Num

SUM 1

COUNTA 2

AVERAGE 3

MAX 4

MIN 5

PRODUCT 6

COUNT 7

STDEV 8

STDEVP 9

VAR 10

VARP 11

Total is an Array of column offsets corresponding to the Add Subtotal To list box. Indicates which columns you want aggregated according to function_num; for example, {4,5}

Replace is a logical value which, if TRUE, causes any previous subtotals to be replaced by new subtotals. If FALSE or omitted, subtotals will not be replaced.

PageBreaks is a logical value corresponding to the Page Break Between Groups check box which, if TRUE, creates a page break below each subtotal. If FALSE or omitted, does not create a page break below each subtotal.

Summary_Below is a logical value corresponding to the Summary Below Data check box which, if TRUE, places subtotal rows below the data they refer to, and a grand total at the bottom of the list. If FALSE, places subtotal rows above the data they refer to, and a grand total just below the header.

Related Functions

SUBTOTAL.REMOVE Removes all previously existing subtotals and grand totals in a list

List of Command-Equivalent Functions