Excel functions / Database

DSTDEV function

The standard deviation of a column of a table for the matching rows, treating them as a sample.

Syntax

=DSTDEV(database, field, criteria)

Arguments

When to use it

DSTDEV gives the standard deviation of one column of a table for the matching rows, treating them as a sample. DSTDEVP treats them as the whole population.

Examples

  1. How much North sales vary

    ABCDE
    1Region
    2North458.26
    3
    4RegionRepSales
    5NorthAna1200
    6SouthBen800
    7NorthChloe900
    8WestAna400
    9NorthAna300

    In E2: =DSTDEV(A4:C9, "Sales", A1:A2) → 458.26

    Try this example

Common mistakes

DSTDEV in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try DSTDEV in the playground

Related functions