Database
DVARP Function in Excel
Calculates variance based on entire population from database entries matching criteria.
Syntax
- =DVARP(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
- =DVARP(A1:D10, "Values", F1:F2) - Population variance - Result: Variance
D-functions vs DVARP
- 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
- Use when data is entire population
Use cases
- Population statistics
- Complete data analysis
- Variance calculation
Frequently asked questions
- What is the DVARP function in Excel? DVARP calculates variance based on entire population from database entries matching criteria. The syntax is =DVARP(database, field, criteria). Typical use cases include population statistics, complete data analysis, variance calculation.
- How do I use the DVARP function? To use DVARP, type =DVARP( 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 DVARP not working in my Excel? Common issues with DVARP include Use when data is entire population. Start by checking the syntax =DVARP(database, field, criteria), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.