DAVERAGE

Name

DAVERAGE —
DAVERAGE(database,field,criteria)

Description

DAVERAGE function returns the average of the values in a list or database that match conditions specified.

@database is a range of cells in which rows of related information are records and columns of data are fields. The first row of a database contains labels for each column.

@field specifies which column is used in the function. If @field is an integer, i.e. 2, the second column is used. Field can also be the label of a column.

@criteria is the range of cells which contains the specified conditions. The first row of a @criteria should contain the labels of the fields for which the criterias are for. Cells below the label specify coditions, for example, ``>3'' or ``<9''.

See also

DCOUNT