Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in /home/myscript/public_html/classes/classdb.php on line 42
DAVERAGE Function / Formula in Microsoft Excel 2007 | Video Tutorial

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

Learn MS Excel


Ask Questions

Ask Question