Excel like a finance pro.
← The libraryPractice · 2 questions →
Database function
DVAR
Estimates the sample variance of table values that match criteria.
Rarely usedDifficulty 1400 · AdvancedUsage rank #346 of 520
When to use it
Sample variance of a column for rows matching the criteria range.
The shape of it
- Syntax
=DVAR(database, field, criteria)
Worked examples
One condition
=DVAR(A1:E11,"Revenue",H1:H2) → 5,833.333333
West revenues.
Another column
=DVAR(A1:E11,"Units",H1:H2) → 2.333333333
West units.
OR conditions
=DVAR(A1:E11,"Revenue",H1:H3) → 14,200
West or East.
Worth knowing
- VAR.S over a FILTER in Microsoft 365.
- Square root gives DSTDEV.
- Needs at least two matches.
Where it goes wrong
- #DIV/0! with fewer than two matches.
- Units are squared.
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.