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. |