|Get a subtotal in a list or database.|
|=SUBTOTAL( function_num, ref1, [ref2], … )|
|function_num||A number representing a function that will be used to calculate subtotals.|
|ref1||A named range or reference to subtotal.|
|[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.