Difference between revisions of "Manuals/calci/DAVERAGE"
Jump to navigation
Jump to search
| Line 81: | Line 81: | ||
{| id="TABLE2" class="SpreadSheet blue" | {| id="TABLE2" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | | class=" " | | + | | class="sshl_f" | Stationary Items |
| − | | | + | | class="sshl_f" | Count |
| − | | class=" | + | | class="sshl_f" | Price |
| − | | | + | | class="sshl_f" | Profit |
| − | + | ||
|- class="odd" | |- class="odd" | ||
| − | | class=" " | | + | | class="sshl_f" | Pen |
| − | | class="sshl_f | + | | class="sshl_f" | <30 |
| + | | class="sshl_f" | | ||
| + | | class="ssh1_f" | >10 | ||
| + | |||
| + | | class="even" | ||
| + | | class="sshl_f" | Stationary Items | ||
| class="sshl_f" | Count | | class="sshl_f" | Count | ||
| − | | class="sshl_f " | Price | + | | class="sshl_f" | Price |
| class="sshl_f" | Profit | | class="sshl_f" | Profit | ||
| − | |- class=" | + | |
| − | + | |- class="odd" | |
| class="sshl_f" | Pen | | class="sshl_f" | Pen | ||
| − | | class="sshl_f | + | | class="sshl_f" | 10 |
| class="sshl_f" | 40 | | class="sshl_f" | 40 | ||
| class="sshl_f" | 10 | | class="sshl_f" | 10 | ||
| − | |- class=" | + | |
| − | + | |- class="even" | |
| class="sshl_f" | Pencil | | class="sshl_f" | Pencil | ||
| − | | class="sshl_f | + | | class="sshl_f" | 20 |
| − | |||
| class="sshl_f" | 30 | | class="sshl_f" | 30 | ||
| − | | class="sshl_f | + | | class="sshl_f" | 15 |
| − | |- class=" | + | |
| − | + | |- class="odd" | |
| class="sshl_f" | Books | | class="sshl_f" | Books | ||
| class="sshl_f" | 15 | | class="sshl_f" | 15 | ||
| − | | class="sshl_f " | 75 | + | | class="sshl_f" | 75 |
| − | | class=" " | 20 | + | | class="ssh1_f" | 20 |
| − | |- class=" | + | |
| − | | class=" " | | + | |- class="even" |
| − | | class="sshl_f | + | | class="sshl_f" | Pen |
| + | | class="sshl_f" | 30 | ||
| + | | class="sshl_f" | 50 | ||
| class="sshl_f" | 48.3333 | | class="sshl_f" | 48.3333 | ||
| − | |||
| − | |||
|} | |} | ||
<div align="left">[[Image:calci1.gif]]</div></div> | <div align="left">[[Image:calci1.gif]]</div></div> | ||
---- | ---- | ||
Revision as of 11:06, 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.
Examples
Consider the following table with Stationary Items, Count, Price and Profit.
| Stationary Items | Count | Price | Profit | |||||
| Pen | <30 | >10 | class="even" | Stationary Items | Count | Price | Profit | |
| Pen | 10 | 40 | 10 | |||||
| Pencil | 20 | 30 | 15 | |||||
| Books | 15 | 75 | 20 | |||||
| Pen | 30 | 50 | 48.3333 |
