DSTDEVP Function in Excel: Syntax, Examples and Free Practice
DSTDEVP is an Excel Database function. Calculates standard deviation from a full population matching a set of conditions.
DSTDEVP syntax
Arguments
database: The range that makes up the table, including headersfield: Which column to evaluate, by name or positioncriteria: The range containing the conditions to apply
When to use DSTDEVP
DSTDEVP is used to summarize a structured table based on multiple criteria at once, similar to a filtered PivotTable.
Practice DSTDEVP online, free
Open the live Excel-style spreadsheet and try DSTDEVP yourself. No Excel install or sign-up needed to start.
Practice DSTDEVP now →More Database functions
Frequently asked questions
What does the DSTDEVP function do in Excel?
Calculates standard deviation from a full population matching a set of conditions.
What is the syntax of DSTDEVP in Excel?
The syntax is =DSTDEVP(database, field, criteria). database: The range that makes up the table, including headers; field: Which column to evaluate, by name or position; criteria: The range containing the conditions to apply.
Where can I practice DSTDEVP online for free?
Open the free live spreadsheet on Cellgrids and try DSTDEVP yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Database functions · Excel case studies · Excel tutorials · Excel shortcuts