DSTDEVP Function
Calculates the standard deviation of matching records, treating them as the whole population.
Category
Database
Available in
All versions, Microsoft 365
Returns
A number
Want to practice DSTDEVP in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
DSTDEVP measures the spread of the field values when the matching records are the entire population (it divides by n, like STDEV.P).
Its answer is always a little smaller than DSTDEV's for the same records.
Syntax
=DSTDEVP(database, field, criteria) Explain
Arguments
| Argument | Required? | What it does |
|---|---|---|
| database | Yes | The whole list, including the header row — e.g. A1:E7. Each row is a record, each column a field. |
| field | Yes | Which column to calculate: its header in quotes ("Sales"), a cell holding the header, or its position (5 = the fifth column). |
| criteria | Yes | A small range with at least one header copied exactly from the list and the conditions underneath, e.g. G1:G2. |
Examples
Example 1 — Spread of every Paper sale
These three are all the Paper orders there are, so treat them as the population.
G5fx=DSTDEVP(A1:E7,"Sales",G1:G2)
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Region | Rep | Product | Units | Sales | Product | |
| 2 | North | Amara | Paper | 40 | 520 | Paper | |
| 3 | South | Ben | Toner | 12 | 576 | ||
| 4 | North | Chloe | Toner | 8 | 384 | Std dev (pop.) | |
| 5 | East | Dev | Paper | 25 | 325 | 81.07 | |
| 6 | North | Amara | Pens | 100 | 120 | ||
| 7 | South | Ella | Paper | 30 | 390 |
=DSTDEVP(A1:E7,"Sales",G1:G2) Explain
Common mistakes
- Sample or population? If the records are a sample used to judge a bigger group, use DSTDEV instead.
Notes
- Criteria rules: conditions on the same row must all be true (AND); conditions on separate rows are alternatives (OR). Text such as Nor matches anything that begins with it — type ="=North" for an exact match. Use >500, <>East, or wildcards like *Paper*.
- Related functions: DSUM, DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DVAR, DVARP.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.