SUBTOTAL function

description:

Get a subtotal in a list or database.

 

syntax:

=SUBTOTAL( function_numref1[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.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.