writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 15:
Line 15: − + − − * A 'column name' in quotes (e.g. "Price") or 'column number' (e.g. 3, if Price is 3rd column) can be used as 'field' argument.
Manuals/calci/DAVERAGE (view source)
Revision as of 22:05, 11 November 2013
, 22:05, 11 November 2013no edit summary
It averages the values in a column of a list or database that match the specified condition.
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 'field' argument can be expressed as "Price" (a column name) or '3' (position of column number).
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.
*Criteria can be any range on the 'Calci' with minimum of one column and at least one row indicating the condition.