Manuals/calci/DAVERAGE

From ZCubes Wiki
Revision as of 06:34, 11 November 2013 by Swapna (talk | contribs)
Jump to navigation Jump to search

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