DVAR

Excel Functions

Get sample variance for matching records

Syntax

EXCEL

=DVAR(database, field, criteria)

Arguments

Parameter	Description
`database`	Database range including headers.
`field`	Field name or index to count.
`criteria`	Criteria range including headers.

Return Value

The calculated variance

Details

The Excel DVAR function gets the variance of a sample extracted from records matching criteria, using values in a given field. The database argument is a range of cells that includes field headers, field is the name or index of the field to get a max value from, and criteria is a range of cells with headers that match those in database. Using the example above, you can get the variance of heights for the group "Fox" with either of these formulas: The criteria can include a variety of expressions, including some wildcards. The table below shows some examples: Note: Support for wildcards is not quite the same as with other functions like COUNTIFS, SUMIFS, MATCH, etc. For example, the pattern ??? will match strings with 3 exactly characters in more modern functions, but not in the database fu

Examples

Example 1

Using the example above, you can get the variance of heights for the group "Fox" with either of these formulas: