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

Want to practice STDEVPA 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

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

=STDEVPA(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 — 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.

E2fx=STDEVPA(B2:B8)
ABCDE
1NameScoreMeasureResult
2Ana82STDEVPA41.87
3BenabsentSTDEV.P36.43
4Cy91
5Di
6Ed77
7Fay0
8Guspending
=STDEVPA(B2:B8) Explain

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

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.