DAVERAGE()
Syntax. DAVERAGE(database,field,criteria)
Definition. This function returns the arithmetic mean for the values in a list or database column that match the specified conditions.
Arguments
database (required) The cell range that makes up the list or database
field (optional) Indicates which column is used in the function
criteria (required) The cell range containing the field names and the filter criteria
Background. The arithmetic mean is the best known mean value. Because it can easily be calculated, it plays an important role in summarizing and analyzing data.
To calculate the mean, the values in a range are added and the sum is divided by the number of values.
See Also
You will find more information about the mean in the description of AVERAGE() ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
