Updated: May 2, 2019
This Function is used to find the average of a particular item chosen from a particular criteria
This is a combination of IF and Average Function.Examines a list of information and produces and average.
The DatabaseRange is the entire list of information you need to examine, including the field names at the top of the columns.
The FieldName is the name, or cell, of the values to be averaged, such as "Marks" or D2
The Criteria Range is made up of two types of information..
The first set of information is the name,
The second set of information is the actual record, or records
Here is the video tutorial of the same for clear understanding.