VAR.P Function
Calculates the variance of an entire population.
Category
Statistical
Available in
Excel 2010+, Microsoft 365
Returns
A number
Overview
VAR.P returns the average squared distance from the mean, treating the numbers as the whole group: the sum of squared deviations divided by n.
Use the .S (sample) version when your numbers are a sample of a bigger group — some customers, some days, some products — and the .P (population) version when they are the entire group you care about. The sample version divides by n − 1 instead of n, which makes it slightly larger to allow for the people you didn't measure.
In a range, text, TRUE/FALSE and empty cells are ignored. Numbers, logical values and numbers-as-text typed straight into the argument list are counted.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number1 | Yes | A number, cell or range covering the whole population. |
| number2, … | No | Up to 254 more numbers, cells or ranges. |
Examples
Example 1 — Variance across the whole team
All seven reps are the population.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Sales | Measure | Result |
| 2 | Ana | North | 62000 | Population | 91533367.35 |
| 3 | Ben | South | 48500 | Sample | 106788928.57 |
| 4 | Cy | North | 50000 | ||
| 5 | Di | East | 71250 | ||
| 6 | Ed | South | 39800 | ||
| 7 | Fay | North | 55400 | ||
| 8 | Gus | East | 48500 |
VAR.P × n ÷ (n − 1) gives VAR.S: 91,533,367.35 × 7 ÷ 6 = 106,788,928.57.
Common mistakes
- #DIV/0! The range contains no numbers.
- Squared units. The result is in dollars², so take the square root (or use STDEV.P) to get back to dollars.
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.