Database
DSTDEVP Function in Excel
Calculates standard deviation based on entire population from database entries matching criteria.
Syntax
- =DSTDEVP(database, field, criteria)
Arguments
- database (required): Range including headers
- field (required): Column for std dev (name or number)
- criteria (required): Range with criteria headers and values
Examples
- =DSTDEVP(A1:D10, "Values", F1:F2) - Population std dev - Result: Std dev
D-functions vs DSTDEVP
- 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
- Variability measurement
Frequently asked questions
- What is the DSTDEVP function in Excel? DSTDEVP calculates standard deviation based on entire population from database entries matching criteria. The syntax is =DSTDEVP(database, field, criteria). Typical use cases include population statistics, complete data analysis, variability measurement.
- How do I use the DSTDEVP function? To use DSTDEVP, type =DSTDEVP( 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 DSTDEVP not working in my Excel? Common issues with DSTDEVP include Use when data is entire population. Start by checking the syntax =DSTDEVP(database, field, criteria), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.