SUBTOTAL function


DESCRIPTION:

Get a subtotal in a list or database.

 

SYNTAX:

=SUBTOTAL( function_num, ref1[ref2], ... )

 

REQUIRED ARGUMENTS:

function_num

A number representing a function that will be used to calculate subtotals.

ref1

A named range or reference to subtotal.

 

OPTIONAL ARGUMENTS:

[ref2]

A named range or reference to subtotal.