Daverage Function in Excel: Syntax, Examples, and Tips

This article provides a clear overview of Daverage Function in Excel, with the main facts, useful context, and practical details organized for easy reading.

this guide shows the syntax and usage of Daverage function to calculate the average value with a given condition.

Description

Daverage function is a function of calculating the average value with a given condition.

Syntax

DAVERAGE (database, field, criteria)

Arguments

- database: is the range of cells, list or database including the title and the required parameters.

- field: specify the column used in the function, the cell contains the column header or column header name (you need to enter the column header name enclosed in quotation marks). It is also possible to use a number to represent the column position, for example the first column is 1, the second column is 2, etc.

- criteria: range of cells containing conditions, you can use any range as long as the range contains at least one column header and at least one cell contains conditions under that column header.

For Example

Give the data table as follows:

The average number of products sold by Sex workers is Female.

1. You can use a formula with the field parameter as the cell containing the column header:

= DAVERAGE (A8: F15, E8, D5: D6)

2. Or use a formula with the field parameter as the column header name:

= DAVERAGE (A7: F14, "Number of products sold", D4: D5)

3. You can also use a formula with a field parameter that represents a column position:

= DAVERAGE (A7: F14,5, D4: D5)

All three ways have the same results, you can choose how to enter the field parameters as you like.

In the article, I introduced the syntax and presented an example of using Daverage function to calculate the average value with a given condition. Hope the article will help you. Good luck!