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.

Stationary Items	Count	Price	Profit
Pen	<30		>10
Stationary Items	Count	Price	Profit
Pen	10	40	10
Pencil	20	30	15
Books	15	75	20
Pen	30	50	48.3333

File:Calci1.gif

---