DPRODUCT (PQL - xl)
This function multiplies the values in a column of a list or database that match the specified conditions
- Library: PQL \ Spreadsheet \ Database
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
DPRODUCT(database, field, criteria)
Function Arguments
Name | Description | Type | Optional |
database | Range of cells that make up the database; cell range reference | CellRange |
|
field | Column in the database, referred to by label or index | StringOrNumber |
|
criteria | Range of cells that specify which rows in the database are used; cell range reference | CellRange |
|
Comments
This function is the same as the Microsoft Excel 'DPRODUCT' function - using the same inputs, logic and outputs.