DCOUNTA (PQL - xl)
This function counts the non-blank cells 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
DCOUNTA(database, OPTIONAL 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 | Y |
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 'DCOUNTA' function - using the same inputs, logic and outputs.