What is the syntax for STDEVA in Excel?

The syntax for STDEVA is: =STDEVA(value1, [value2], ...)

What are common errors with STDEVA?

Text and FALSE evaluate to 0, TRUE to 1

How do I use the STDEVA function?

To use STDEVA, type =STDEVA( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does STDEVA work with?

STDEVA works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is STDEVA not working in my Excel?

Common issues with STDEVA include Text and FALSE evaluate to 0, TRUE to 1. Start by checking the syntax =STDEVA(value1, [value2], ...), then verify each referenced cell or range.

Statistical

STDEVA Function in Excel

Estimates standard deviation based on a sample, including text and logical values.

Syntax

=STDEVA(value1, [value2], ...)

Arguments

value1 (required): First value or range
value2 (optional): Additional values or ranges

Examples

=STDEVA(1, 2, 3, TRUE) - StdDev with TRUE (=1) - Result: 0.9574
=STDEVA(A1:A10) - StdDev including text as 0 - Result: Standard deviation

STDEVA for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

Text and FALSE evaluate to 0, TRUE to 1

Use cases

Sample standard deviation with mixed data
Survey analysis

Frequently asked questions

What is the STDEVA function in Excel? STDEVA estimates standard deviation based on a sample, including text and logical values. The syntax is =STDEVA(value1, [value2], ...). Typical use cases include sample standard deviation with mixed data, survey analysis.
How do I use the STDEVA function? To use STDEVA, type =STDEVA( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does STDEVA work with? STDEVA works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is STDEVA not working in my Excel? Common issues with STDEVA include Text and FALSE evaluate to 0, TRUE to 1. Start by checking the syntax =STDEVA(value1, [value2], ...), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.