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
| Argument | Required? | What it does |
|---|---|---|
| value1 | Yes | A value, cell or range covering the population. |
| value2, … | No | Up 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)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Score | Measure | Result | |
| 2 | Ana | 82 | VARPA | 1752.89 | |
| 3 | Ben | absent | VAR.P | 1327.25 | |
| 4 | Cy | 91 | |||
| 5 | Di | ||||
| 6 | Ed | 77 | |||
| 7 | Fay | 0 | |||
| 8 | Gus | pending |
=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

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.