DAVERAGE
TheDAVERAGE
function calculates the average value of a specified field in a database that matches the given criteria. The function is commonly used in financial and business analysis to calculate averages based on specific conditions.
 How to use
DAVERAGE
formula?  Examples of using
DAVERAGE
formula DAVERAGE
formula not working? Similar formulas to
DAVERAGE
Usage
Use the DAVERAGE
formula with the syntax shown below, it has 3 required parameters:
 database (required):
The range of cells that makes up the database.  field (required):
The column or field that contains the values to be averaged.  criteria (required):
The range of cells that contains the conditions to be met. Each column in the range represents a field in the database, and each row represents a different condition.
Examples
Here are a few example use cases that explain how to use theDAVERAGE
formula in Google Sheets.
Calculate the average sales for a specific product
Use DAVERAGE
to calculate the average sales for a specific product in a sales database. Set the field
argument to the column that contains the sales values, and the criteria
argument to a range that includes the product name and any other conditions that must be met.
Calculate the average grade for a specific student
Use DAVERAGE
to calculate the average grade for a specific student in a gradebook database. Set the field
argument to the column that contains the grade values, and the criteria
argument to a range that includes the student name and any other conditions that must be met.
Calculate the average temperature for a specific month
Use DAVERAGE
to calculate the average temperature for a specific month in a weather database. Set the field
argument to the column that contains the temperature values, and the criteria
argument to a range that includes the month name and any other conditions that must be met.
Common Mistakes
DAVERAGE
not working? Here are some common mistakes people make when using the DAVERAGE
Google Sheets Formula:
Incorrect cell range for database
One common mistake is selecting the incorrect cell range for the database argument. Make sure that the cell range includes all the data and headers of the database.
Incorrect field header
Another mistake is providing an incorrect field header for the field argument. Make sure that the header matches the exact spelling and capitalization in the database.
Incorrect criteria format
A common mistake is not providing the criteria argument in the correct format. Make sure it follows the same format as the field header, for example: "=B2".
Database not sorted
If the database is not sorted, the DAVERAGE formula may return unexpected results. Make sure the data is sorted in ascending order by the field column.
Criteria not found
If the criteria does not match any values in the database, the DAVERAGE formula will return a #DIV/0! error. Doublecheck the criteria to ensure it matches a value in the database.
Related Formulas
The following functions are similar to DAVERAGE
or are often used with it in a formula:

DSUM
The
DSUM
function is a database function that calculates the sum of a set of values in a specified field, subject to the provided criteria. It is commonly used for filtering large data sets based on certain criteria and calculating the total sum of a particular field that matches the criteria. 
DCOUNT
The
DCOUNT
function is a database function in Google Sheets that counts the number of cells in a column of a database that match a set of criteria. This function is most commonly used to filter a database based on certain criteria and count the number of cells that meet that criteria. 
DMIN
The
DMIN
function returns the minimum value from a column in a database, based on a specified condition. This function is commonly used to extract specific data from large databases. 
DMAX
The
DMAX
function is a Database function in Google Sheets that returns the maximum value of a single column in a database table that meets specified criteria. The criteria can be specified using multiple conditions. This function is commonly used in data analysis, especially when working with large datasets.
Learn More
You can learn more about the DAVERAGE
Google Sheets function on Google Support.