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.
Syntax:
=DAVERAGE(DatabaseRange,FieldName,CriteriaRange)
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
Example:
Here is the video tutorial of the same for clear understanding.
If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.
You can write us at dptutorials15@gmail.com
Commenti