STDEVA Function

Estimates standard deviation from a sample, counting text and logical values.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

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

STDEVA works like STDEV.S, 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.

That's useful when text means "nothing" — "absent" or "not delivered" really is a zero. When text just means "unknown", use STDEV.S.

Syntax

=STDEVA(value1, [value2], …)

Arguments

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

Examples

Example 1 — Text counted as zero

Ben and Gus have text, Di is blank, and Fay scored 0. STDEVA counts the two text entries as 0; STDEV.S leaves them out.

E2fx=STDEVA(B2:B8)
ABCDE
1NameScoreMeasureResult
2Ana82STDEVA45.86
3BenabsentSTDEV.S42.07
4Cy91
5Di
6Ed77
7Fay0
8Guspending
=STDEVA(B2:B8) Explain

STDEVA uses 82, 0, 91, 77, 0, 0 (six values); STDEV.S uses 82, 91, 77, 0 (four). Di's blank is skipped by both.

Common mistakes

  • Placeholder text skews the result. Notes such as "pending" become zeros. If they mean "not known yet", use STDEV.S, which ignores them.
  • #DIV/0! Fewer than two 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.