This function calculates the arithmetic mean for values within a list or database column that meet specified conditions.
Syntax
DAVERAGE(database; field; criteria)
Arguments
- database (required): The cell range that constitutes the list or database.
- field (optional): Specifies which column the function will use.
- criteria (required): The cell range that contains the field names and the filter criteria.
Background
The arithmetic mean is the most commonly recognized mean value. Its ease of calculation makes it crucial for summarizing and analyzing data. To compute the mean, values in a range are summed, and then the sum is divided by the total number of values.
Use the DAVERAGE() function to calculate the mean for selected database records.
Example
It’s year-end, and you’re analyzing sales. Specifically, you want to determine the average sales of products in various countries. The DAVERAGE() function can help you calculate these values.
To find the average sales for « Chang » in the United States, you would specify « USA » as the country/region and « Chang » as the item name. Since you’re looking for average sales, you’d use « Sales » as the database field. DAVERAGE() would then return $1,522.85 (refer to Figure below).
You also want to calculate the overall average sales for « Chang ». To do this for « Chang » across all countries and regions, simply omit the country/region as a search criterion. This ensures all countries and regions are included in the calculation. DAVERAGE() will return $1,560.02 as the average sales order value (refer to Figure below).
By using the DAVERAGE() function, you can effectively compare the average sales for products across different countries.