DCOUNT (PQL - xl)

This function counts the cells that contain numbers 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

DCOUNT(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 'DCOUNT' function - using the same inputs, logic and outputs.