Formulas > =DAVERAGE()

How To Use DAVERAGE() Function in Google Sheets


Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.

Common Questions:
What is the DAVERAGE formula?
How can the DAVERAGE formula be used?

How Can the DAVERAGE Formula be Used Appropriately?:
The DAVERAGE formula can be used to average data across two or more columns or rows of numbers. The first parameter of the formula is the data range. The second parameter of the formula is the criteria range. This criteria can include conditions such as the value in a particular column or row, or certain figures.

How Can the DAVERAGE Formula be Commonly Mistyped?:
The DAVERAGE formula is commonly mistyped as either ""DAVRAGE"" or ""DAAVERAGE.""

What are some Common Ways the DAVERAGE Formula is Used Inappropriately?:
The DAVERAGE formula can be used inappropriately by not specifying the criteria range, or by giving criteria values not relevant to the data set. It can also be used inappropriately by specifying the wrong data range or incorrectly using absolute or relative references.

What are Some Common Pitfalls When Using the DAVERAGE Formula?:
When using the DAVERAGE formula, it is important to avoid duplication of criteria, as this can lead to incorrect or unexpected results. Additionally, users should not forget to include the criteria range as this can lead to incorrect results.

What are Common Mistakes When Using the DAVERAGE Formula?:
Common mistakes when using the DAVERAGE formula include forgetting to include the criteria range, incorrect use of absolute and relative references, improper use of date-related criteria, and using criteria values that are not relevant to the data set.

What are Common Misconceptions People Might Have with the DAVERAGE Formula?:
A common misconception with the DAVERAGE formula is that it only averages data from two or more columns or rows, when in fact it can also average data across multiple columns or rows. Additionally, some people may think that the DAVERAGE formula always requires both a data range and a criteria range when that is actually not always the case.

How To Actually Use DAVERAGE() in Sheets

DAVERAGE(database, field, criteria)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the DAVERAGE() formula:

google sheets daverage function database field criteria

Use the Google Sheets DAVERAGE function to get the average of numbers in a field of a database, based on one or more criterion. The DAVERAGE function needs three parameters. They are the database, field, and criteria.

Generate a DAVERAGE() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.