VARPA Function

Calculates variance of a whole population, counting text and logical values.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice VARPA in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

VARPA works like VAR.P, but it doesn't skip text and logical values in a range.

The "A" versions count text and FALSE as 0 and TRUE as 1 when they sit in a range; empty cells are still ignored.

Syntax

=VARPA(value1, [value2], …)

Arguments

ArgumentRequired?What it does
value1YesA value, cell or range covering the population.
value2, …NoUp to 254 more values, cells or ranges.

Examples

Example 1 — Population variance with text as zero

Ben and Gus have text, Di is blank, and Fay scored 0.

E2fx=VARPA(B2:B8)
ABCDE
1NameScoreMeasureResult
2Ana82VARPA1752.89
3BenabsentVAR.P1327.25
4Cy91
5Di
6Ed77
7Fay0
8Guspending
=VARPA(B2:B8) Explain

VARPA divides by the six values counted; VAR.P by the four numbers.

Common mistakes

  • #DIV/0! No values are counted.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.