Excel like a finance pro.
← The libraryPractice · 2 questions →
Database function
DSTDEV
Estimates the sample standard deviation of table values that match criteria.
Rarely usedDifficulty 1400 · AdvancedUsage rank #344 of 520
When to use it
Sample standard deviation of a column for rows matching the criteria range.
The shape of it
- Syntax
=DSTDEV(database, field, criteria)
Worked examples
One condition
=DSTDEV(A1:E11,"Revenue",H1:H2) → 76.37626158
West revenues 100, 150, 250.
Another column
=DSTDEV(A1:E11,"Units",H1:H2) → 1.527525232
West units 2, 3, 5.
OR conditions
=DSTDEV(A1:E11,"Revenue",H1:H3) → 119.1637529
West or East: 100, 150, 250, 200, 400.
Worth knowing
- STDEV.S over a FILTER does the same in Microsoft 365.
- Needs at least two matching rows.
- DSTDEVP for populations.
Where it goes wrong
- #DIV/0! with fewer than two matches.
- Header mismatches drop rows silently.
Related
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.