SUBTOTAL
Returns a subtotal in a list or database.
Syntax
expression.SUBTOTAL(arg1, args);
expression - A variable that represents a ApiWorksheetFunction class.
Parameters
| Name | Required/Optional | Data type | Default | Description |
|---|---|---|---|---|
| arg1 | Required | ApiRange | ApiName | number | A numeric value that specifies which function to use for the subtotal: -1 (101) - AVERAGE, -2 (102) - COUNT,\ -3 (103) - COUNTA, -4 (104) - MAX, -5 (105) - MIN,\ -6 (106) - PRODUCT, -7 (107) - STDEV, -8 (108) - STDEVP, -9 (109) - SUM, -10 (110) - VAR, -11 (111) - VARP.\ 1-11 includes manually-hidden rows, while 101-111 excludes them;\ filtered-out cells are always excluded. | |
| args | Required | ApiRange | ApiName | Up to 255 ranges containing the values for which the subtotal will be returned. The first argument is required, subsequent arguments are optional. |
Returns
number
Example
- Code
- Result
let worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
worksheet.GetRange("A1").SetValue(func.SUBTOTAL(9, 10, 30, 50, 5));