SUBTOTAL (PQL - xl)
This function calculates a subtotal of a list of numbers using a specified built-in function
- Library: PQL \ Spreadsheet \ Math & Trig
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
SUBTOTAL(function num, ref1, ref2)
Function Arguments
Name | Description | Type | Optional |
function num | The number that represents the built-in function to use for the subtotal | Number |
|
ref1 | Double-precision floating-point value, an integer value, or an array (cell range) of these | StringOrNumber |
|
ref2 | Double-precision floating-point value, an integer value, or an array (cell range) of these | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'SUBTOTAL' function - using the same inputs, logic and outputs.