In this article
STDEVA is STDEV.S that also counts text as 0 and TRUE as 1; STDEV.S ignores them.
Advertisement
Syntax
=STDEVA(value1, [value2], ...)| Argument | What it means |
|---|---|
value1… |
Values, text or logicals |
Examples
Example 1
=ROUND(STDEVA(A2:C2),3)Result: 43.589. See the worked example table below for more cases.
STDEVA in practice
Where you will use it
- Data where 'Absent' should count as 0
- Logical survey answers
- Mixed columns
Worked example
| Value 1 | Value 2 | Value 3 | Formula | Result |
|---|---|---|---|---|
| 80 | Absent | 70 | =ROUND(STDEVA(A2:C2),3) | 43.589 |
| 80 | 70 | TRUE | =ROUND(STDEVA(A3:C3),3) | 43.016 |
| 80 | 70 | 90 | =ROUND(STDEVA(A4:C4),3) | 10 |
Results calculated in Excel. Text counts as 0 and TRUE as 1; compare with the all-numbers row.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Expecting text to be ignored | Text counts as 0 |
| Normal numbers | Use STDEV.S |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong