STDEVPA Function
Calculates standard deviation of a whole population, counting text and logical values.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
Overview
STDEVPA works like STDEV.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
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 — Everyone counts, including no-shows
Ben and Gus have text, Di is blank, and Fay scored 0. These six entries are the whole class, and a no-show scores 0.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Score | Measure | Result | |
| 2 | Ana | 82 | STDEVPA | 41.87 | |
| 3 | Ben | absent | STDEV.P | 36.43 | |
| 4 | Cy | 91 | |||
| 5 | Di | ||||
| 6 | Ed | 77 | |||
| 7 | Fay | 0 | |||
| 8 | Gus | pending |
STDEVPA uses six values (text as 0); STDEV.P uses only the four numbers.
Common mistakes
- #DIV/0! No values are counted.
- Placeholder text becomes 0. Use STDEV.P if text should be left out.
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.