The SUBTOTALfunction returns an aggregate result for supplied values. The SUBTOTAL function can either include or exclude values in hidden rows.
Purpose of Excel SUBTOTAL Function
Get a subtotal in a list or database.
Return value
A number representing a specific kind of subtotal.
Syntax
= SUBTOTAL (function_num, ref1, [ref2], …)
Arguments
| Arguments | Description | Remarks |
| function_num | A number that specifies which function to use in calculating subtotals within a list. | Mandatory |
| ref1 | A named range or reference to the SUBTOTAL. | Mandatory |
| ref2 | A named range or reference to the SUBTOTAL. | Optional |
Availability
Since 2007 for Windows.
Since 2011 for Mac.