Skip to Content

DVARP

Calculates variance based on the entire population of selected database entries

Syntax

DVARP(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

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