Skip to Content

DVAR

Estimates variance based on a sample from selected database entries

Syntax

DVAR(database, field, criteria)

Parameters

  • database: Required. The range of cells that makes up the list or database
  • field: Required. Indicates which column is used in the function
  • criteria: Required. The range of cells that contains the conditions you specify

Example

=DVAR(A1:C10, "Yield", A12:A13)
Returns: NumberSince: Excel 2003