writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + − + − + Line 11:
Line 11: − + − +
no edit summary
= DAVERAGE(database,field,criteria)=
<div style="font-size:30px">'''DAVERAGE (Array,Field,Criteria)'''</div><br/>
*Where 'database' is the range of cells that makes up the list or database
*Where 'Array' is the range of cells that makes up the list or database
*'field' shows which column is used in the function and
*'Field' shows which column is used in the function and
*'criteria' is the range of cells that contains the specified criteria.
*'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.
*DAVERAGE() averages the values in a column of a list or database that match the specified criteria.
== Description ==
== Description ==
DAVERAGE(database, field, criteria)
DAVERAGE (Array,Field,Criteria)
It averages the values in a column of a list or database that match the specified condition.
It averages the values in a column of a list or database that match the specified condition.
* A 'field' argument can be expressed as "Price" (a column name) or 3 (position of column number).
* A 'Field' argument can be expressed as "Price" (a column name) or 3 (position of column number).
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.