Database
DVAR Function in Excel
Estimates variance based on a sample from database entries matching criteria.
Syntax
- =DVAR(database, field, criteria)
Arguments
- database (required): Range including headers
- field (required): Column for variance (name or number)
- criteria (required): Range with criteria headers and values
Examples
- =DVAR(A1:D10, "Values", F1:F2) - Sample variance - Result: Variance
D-functions vs DVAR
- Database functions use a criteria range with headers matching your list.
- For simple AND criteria [SUMIFS](/functions/sumifs/) may be easier to audit.
- Compare [SUMIF vs SUMIFS](/compare/sumif-vs-sumifs/) for reporting patterns.
Common errors
- Needs at least 2 values
Use cases
- Statistical analysis
- Sample variance
- Data spread
Frequently asked questions
- What is the DVAR function in Excel? DVAR estimates variance based on a sample from database entries matching criteria. The syntax is =DVAR(database, field, criteria). Typical use cases include statistical analysis, sample variance, data spread.
- How do I use the DVAR function? To use DVAR, type =DVAR( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
- Why is DVAR not working in my Excel? Common issues with DVAR include Needs at least 2 values. Start by checking the syntax =DVAR(database, field, criteria), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.