Wauvel

Excel like a finance pro.

← The library

Database function

DSTDEVP

Calculates the population standard deviation of table values that match criteria.

Rarely usedDifficulty 1400 · AdvancedUsage rank #345 of 520
Practice · 2 questions →

When to use it

Population standard deviation of a column for rows matching the criteria range.

The shape of it

Syntax
=DSTDEVP(database, field, criteria)

Worked examples

  • One condition

    =DSTDEVP(A1:E11,"Revenue",H1:H2) → 62.36095645

    West revenues as a population.

  • Another column

    =DSTDEVP(A1:E11,"Units",H1:H2) → 1.247219129

    West units.

  • OR conditions

    =DSTDEVP(A1:E11,"Revenue",H1:H3) → 106.5833008

    West or East.

Worth knowing

  • STDEV.P over a FILTER in Microsoft 365.
  • Use only when the matching rows are the whole population.
  • Works with a single match (returns 0).

Where it goes wrong

  • Understates spread on samples.
  • Header mismatches drop rows.

Related

DSUMDAVERAGEDCOUNTDCOUNTADGETDMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.