writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − <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 indicates which column is used in the function and+ − cri is the range of cells that contains the conditions we specify.+ − <br />+ − </div>+ − ----+ − <div id="1SpaceContent" class="zcontent" align="left"> It averages the values in a column of a list or database that match conditions we specify.</div>+ − ----+ − <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">+ + + + + + + − DAVERAGE+ − + − ---- Line 66:
Line 71: − + − <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>+ − ----+ − <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div> − ---- − <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div> − ----
Manuals/calci/DAVERAGE (view source)
Revision as of 12:34, 11 November 2013
, 12:34, 11 November 2013no edit summary
= 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></div>
<!--
<div id="8SpaceContent" class="zcontent" align="left">
<div id="8SpaceContent" class="zcontent" align="left">
</div>
</div>
----
-->
<div id="4SpaceContent" class="zcontent" align="left">
<div id="4SpaceContent" class="zcontent" align="left">