Manuals/calci/DAVERAGE

DAVERAGE(database,field,criteria)

• Where 'database' is the range of cells that makes up the list or database

• 'field' shows which column is used in the function and

• 'criteria' is the range of cells that contains the specified criteria.

• DAVERAGE() averages the values in a column of a list or database that match the specified criteria.

Description

DAVERAGE(database, field, criteria)

It averages the values in a column of a list or database that match the specified condition.

• The argument 'field' is optional. If not mentioned, the function averages all the values from database that match the criteria.

• A 'column name' in quotes (e.g. "Salary") or 'column number' (e.g. 3, if Salary is 3rd column) can be used as 'field' argument.

• Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.

• The Criteria columns should not overlap the list of data.

• DCOUNT() can be used to count the cells having numbers from a list or database that match a specified criteria.

• DCOUNTA() can be used to count the number of non-blank cells from a list of database that match a specified criteria.

Examples

Consider the following table with Stationary Items, Count, Price and Profit.

	Column1	Column2	Column3	Column4
Row1	Stationary Items	Count	Price	Profit
Row2	Pen	10	40	10
Row3	Pencil	20	30	15
Row4	Books	15	75	20
Row5		48.3333

File:Calci1.gif

---