Difference between revisions of "Manuals/calci/DAVERAGE"

From ZCubes Wiki
Jump to navigation Jump to search
Line 8: Line 8:
  
 
*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 ==
Line 72: Line 73:
 
</div>
 
</div>
 
-->
 
-->
 +
== Examples ==
  
 +
Consider the following table with Stationary Items, Count, Price and Profit.
  
 
<div id="4SpaceContent" class="zcontent" align="left">
 
<div id="4SpaceContent" class="zcontent" align="left">

Revision as of 07:37, 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.

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