SUBTOTAL
Returns a subtotal in a list or database. Use function_num 1-11 (include all) or 101-111 (exclude hidden rows). 1=AVERAGE, 2=COUNT, 3=COUNTA, 4=MAX, 5=MIN, 6=PRODUCT, 7=STDEV, 8=STDEVP, 9=SUM, 10=VAR, 11=VARP.
| Category | Aggregate |
| Syntax | SUBTOTAL(function_num, ref1, [ref2], ...) |
Parameters
| Parameter | Required | Description |
|---|---|---|
function_num | Required | The function to use: 1=AVERAGE, 2=COUNT, 3=COUNTA, 4=MAX, 5=MIN, 6=PRODUCT, 7=STDEV, 8=STDEVP, 9=SUM, 10=VAR, 11=VARP. Use 101-111 to exclude hidden rows. |
ref1 | Required | The first range or reference to include in the subtotal. |
ref2 | Optional | Additional ranges or references to include. |
Example
SUBTOTAL(range, criteria)
Auto-generated from the EngCanvas function registry.