The DAVERAGE function with example in Excel

The DAVERAGE function in Excel allows you to calculate the average of values in a specific field (column) of records in a list or database, based on conditions you specify. Let’s break down how it works and explore some examples:

1. Syntax:

   =DAVERAGE(database, field, criteria)
   

   • database: The range of cells that makes up the list or database. It contains related data where rows represent records, and columns represent fields.
   • field: Indicates which column you want to use in the function. You can either enter the column label enclosed in double quotation marks (e.g., “Age” or “Yield”) or a number representing the position of the column within the list (1 for the first column, 2 for the second column, and so on).
   • criteria: The range of cells containing the conditions you specify. It should include at least one column label and at least one cell below the column label where you define a condition for that column.

2. Examples: Let’s consider the following data:

   Table

   Tree	Height	Age	Yield	Profit
   Apple	18	20	14	105
   Pear	12	12	10	96
   Cherry	13	14	9	105
   Apple	14	15	10	75
   Pear	9	8	8	76.8
   Apple	8	9	6	45

   • To find the average yield of apple trees over 10 feet in height:

     =DAVERAGE(A4:E10, "Yield", A1:B2)
     

     This formula returns an average yield of 12.

   • To calculate the average age of all trees in the database:

     =DAVERAGE(A4:E10, 3, A4:E10)
     

     This formula returns an average age of 13.

3. Criteria Examples:

   • You can type an equal sign in a cell to indicate a formula. To display text that includes an equal sign, surround the text and equal sign with double quotes (e.g., "=Davolio").
   • If you want to perform an operation on an entire column in the database, enter a blank line below the column labels in the criteria range.

Remember to replace cell references (A4:E10, A1:B2, etc.) with your actual data. The DAVERAGE function is handy when you need to analyze subsets of data based on specific conditions.