Buzz
You often use the Average function to calculate the average value for data in an Excel spreadsheet. But if you need to calculate the average value with specified conditions, the Average function cannot handle it unless you combine it with another function. Daverage function can help you calculate the average value with specified conditions, without needing to combine functions.
This article explains the syntax and how to use the Daverage function to calculate the average value with specified conditions.
Description
Daverage function is used to calculate the average value with specified conditions.
Syntax
DAVERAGE(database, field, criteria)
Where:
- database: refers to the range of cells, list, or database including headers, it is a required parameter.
- field: specifies the column used in the function, the cell containing the column header or the column header name should be provided (you need to enter the column header name in double quotes). You can also use a number to indicate the column position, for example, the first column is 1, the second column is 2...
- criteria: refers to the range of cells containing conditions, you can use any range as long as it contains at least one column header and at least one cell containing a condition under that column header.
Example
Given the following data table:
Calculate the average number of products sold by employees whose Gender is Female.
1. You can use the formula with the field parameter as the cell containing the column header:
=DAVERAGE(A8:F15, E8, D5:D6)
2. Alternatively, you can use the formula with the field parameter as the column header name:
=DAVERAGE(A7:F14,'Number of products sold', D4:D5)
3. You can also use the formula with the field parameter as a number indicating the column position:
=DAVERAGE(A7:F14,5,D4:D5)
All three methods yield the same result, you can choose the field parameter input method as you prefer.
The article has introduced the syntax and provided examples of using the Daverage function to calculate the average value with specified conditions. Hopefully, the article will be helpful to you. Wish you success!
