Wauvel

Excel like a finance pro.

← The library

Database function

DVARP

Calculates the population variance of table values that match criteria.

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

When to use it

Population variance of a column for rows matching the criteria range.

The shape of it

Syntax
=DVARP(database, field, criteria)

Worked examples

  • One condition

    =DVARP(A1:E11,"Revenue",H1:H2) → 3,888.888889

    West revenues as a population.

  • Another column

    =DVARP(A1:E11,"Units",H1:H2) → 1.555555556

    West units.

  • OR conditions

    =DVARP(A1:E11,"Revenue",H1:H3) → 11,360

    West or East.

Worth knowing

  • VAR.P over a FILTER in Microsoft 365.
  • Square root gives DSTDEVP.
  • Only for whole populations.

Where it goes wrong

  • Understates variance on samples.
  • Units are squared.

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.