Database
DSTDEV Function in Excel
Estimates standard deviation based on a sample from database entries matching criteria.
Syntax
- =DSTDEV(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
- =DSTDEV(A1:D10, "Values", F1:F2) - Sample std dev of matching values - Result: Std dev
D-functions vs DSTDEV
- 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
- Data variability
- Sample statistics
Frequently asked questions
- What is the DSTDEV function in Excel? DSTDEV estimates standard deviation based on a sample from database entries matching criteria. The syntax is =DSTDEV(database, field, criteria). Typical use cases include statistical analysis, data variability, sample statistics.
- How do I use the DSTDEV function? To use DSTDEV, type =DSTDEV( 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 DSTDEV not working in my Excel? Common issues with DSTDEV include Needs at least 2 values. Start by checking the syntax =DSTDEV(database, field, criteria), then verify each referenced cell or range.
Editorial review
- Reviewed by Excel.Directory Editorial Team. Updated May 2026.