DVAR Function
The DVAR function is used to find the variance of a list of items from a table/database range, based on the condition provided.
Formula:
=DVAR(Database Range, Field Name, Criteria Range)
Whereas DatabaseRange is the entire table/database (including the title), FieldName is the field whose variance has to be found and CriteriaRange is the name of the FieldName.
Video Tutorial:
Let us find the variance of a list of items from the table/database, using DVAR function, with the help of the below video.
