EXCEL DAVERAGE

The DAVERAGE is an Excel function that returns the average in a given field for records that match the criteria.

Syntax:

=DAVERAGE(database,field,criteria)

Arguments or Parameters

database: The range of cells that you want to apply criteria against.
field : Field name or index to count.
criteria: The range of cells that meet the criteria.

Objective: Find the average Price of Dell Product where Quantity is greater 2.

Step 1:

Type = sign in cell I6.
Type DAVERAGE Function.

Step 2:

Select range A2:F21
Type “,”

Step 3:

Type F2
Type “,”
Select H2:H4
Close Bracket with “)”
Press Enter

Result: The DAVERAGE function has given the average price of Dell where the Quantity is greater than 2.