DAVERAGE

Formulas / DAVERAGE
Calculate the average from matching records.
=DAVERAGE(database,fiel, [crietria])
  • database - a range of cells that includes field headers
  • field - the name or index of the field to get a max value from
  • criteria - [OPTIONAL] a range of cells that match the headers in the database

Examples

  • =DAVERAGE(B7:E14,"Price",B4:E5)

    The DAVERAGE() function can be used to calculate the average value of a specific field from a range of data. This is an example of the DAVERAGE() function that returns the average value from the field "Price" of all items in the inventory of colors "red" and quantity > 2.

  • =DAVERAGE(B7:E14,"Price",B4:E5,"Color","Blue")

    The DAVERAGE() function can also be used to calculate the average value of a specific field from a filtered range of data. The formula above is an example of the DAVERAGE() function that returns the average value from the field "Price" of all items in the inventory of color "blue".

  • =DAVERAGE(B7:E14,"Price",B4:E5,"Color","Blue","Size","Large")

    The DAVERAGE() function can be used to calculate the average value of a specific field from a range of data with multiple criteria. This an example of the DAVERAGE() function that returns the average value from the field "Price" of all items in the inventory of color "blue" and size "large".

Summary

The DAVERAGE function is a worksheet function used to calculate the average of numbers by using given criteria. It works with lists or databases and can be part of a formula in a worksheet.

  • The DAVERAGE function requires three arguments: a database, field, and criteria. The database is a range of cells that includes field headers, the field is the name or index of the field to get a max value from, and the criteria is a range of cells with matching headers in the database.
  • The DAVERAGE function calculates the average of a field for a subset of records and returns the average value.


Frequently Asked Questions

What is the DAVERAGE Function?
The DAVERAGE function is a Sourcetable function that averages values in a field (column) of records in a list or database.
How does the DAVERAGE Function Work?
The DAVERAGE function adds up the values from a field of records in a list or database, and then divides the sum of the values by the number of records. The result is the average of the values in the field.
What are the Syntax and Arguments of the DAVERAGE Function?
The syntax of the DAVERAGE function is:
  • DAVERAGE(database, field, criteria)
where:
  • database: The range of cells that makes up the list or database. A database is a list of related data in which rows of related information are records, and columns of data are fields.
  • field: The column number in the list or database that contains the data you want to average.
  • criteria: The range of cells that contains the conditions you specify. The function will average only the records that meet the specified criteria.
What are the Limitations of the DAVERAGE Function?
The DAVERAGE function has the following limitations:
  • It cannot be used with non-numeric data.
  • It cannot be used with data that is stored in an array.
  • It cannot be used to calculate the average of data from multiple fields.
How do I Use the DAVERAGE Function?
To use the DAVERAGE function:
Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV