Practice free

STDEVA function

STDEVA returns the sample standard deviation while counting text and logical values: TRUE counts as 1, and FALSE and text in ranges count as 0. It is rarely used, and STDEV.S suits clean numeric data.

Example

Read it as a sentence: estimate the standard deviation of the sample in A1:A8, counting any text and logical values too, which gives 2.138089935.

Practice this in the app

Syntax

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

Arguments in [square brackets] are optional.

value1 (required)
First value or range.
value2 (optional)
More values or ranges.

Returns: The sample standard deviation counting text and logicals.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=STDEVA({2,4,4,4,5,5,7,9}) 2.138089935 Array constant
=STDEVA(10,"20",TRUE) 9.504384953 Direct args: number, text-number, TRUE
=STDEVA({1,"2",TRUE,3}) 1.414213562 Array with text and boolean
=STDEVA(Data!A1:A8) 2.138089935 Range of numbers
=STDEVA(Data!B1:B8) 16.65189822 Mixed range: num, text-number, TRUE, blank, text, FALSE
=STDEVA(Data!E1:E5) 0 All-text range
=STDEVA(10,"abc") #VALUE! Direct arg: non-numeric text
=STDEVA(5) #DIV/0! Single number

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • Text in ranges drags results toward 0.
  • Prefer STDEV.S for clean numeric data.

Where it works

Excel
STDEVA is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .