STDEVA Function
Estimates standard deviation from a sample, counting text and logical values.
Category
Statistical
Available in
All versions, Microsoft 365
Returns
A number
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| value1 | Yes | A value, cell or range from the sample. |
| value2, … | No | Up 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.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Score | Measure | Result | |
| 2 | Ana | 82 | STDEVA | 45.86 | |
| 3 | Ben | absent | STDEV.S | 42.07 | |
| 4 | Cy | 91 | |||
| 5 | Di | ||||
| 6 | Ed | 77 | |||
| 7 | Fay | 0 | |||
| 8 | Gus | pending |
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

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.