DAVERAGE
Returns the average of selected database entries
Syntax
DAVERAGE(database, field, criteria)
Parameters
- database: Required. The range of cells that makes up the list or database
- field: Required. Indicates which column is used in the function. Enter the column label or a number (1 for the first column, etc.)
- criteria: Required. The range of cells that contains the conditions you specify
Example
=DAVERAGE(A1:C10, "Yield", A12:A13)