Difference between revisions of "Manuals/calci/DAVERAGE"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> DAVERAGE(db,fld,cri) <br /> where db is the range of cells that makes up the list or database, fld indicat...") |
|||
| Line 1: | Line 1: | ||
| − | + | = 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. | |
| − | < | + | <!-- |
| − | |||
<div id="8SpaceContent" class="zcontent" align="left"> | <div id="8SpaceContent" class="zcontent" align="left"> | ||
| Line 66: | Line 71: | ||
</div> | </div> | ||
| − | -- | + | --> |
| − | + | ||
| − | + | ||
| − | |||
| − | |||
| − | |||
| − | |||
<div id="4SpaceContent" class="zcontent" align="left"> | <div id="4SpaceContent" class="zcontent" align="left"> | ||
Revision as of 07:34, 11 November 2013
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.
| 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 |
