DAVERAGE (PQL - xl)

This function calculates the average of 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

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