81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



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

How To Use in Sheets

DAVERAGE(database, field, criteria)

External Links

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.

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.