DAVERAGE Function
The DAVERAGE function is used to calculate the average of items from a table/database range.
Formula:
=DAVERAGE(DatabaseRange,FieldName,CriteriaRange)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field for which the average has to be calculated and CriteriaRange is the name of the FieldName.
Video Tutorial:
Let us find the average of items from the table/database, using DAVERAGE function, with the help of the below video
