Excel functions / Statistics

STDEVA function

The standard deviation of a sample, counting text and FALSE in a range as 0 and TRUE as 1. STDEV skips them.

Syntax

=STDEVA(value1, [value2], …)

Arguments

When to use it

STDEVA gives the standard deviation of a sample like STDEV, but counts text and FALSE in a range as 0 and TRUE as 1.

Examples

  1. Text and logical values counted

    ABC
    1Value
    2104.86
    3n/a
    4TRUE
    5FALSE

    In C2: =STDEVA(A2:A5) → 4.86

    The values counted are 10, 0, 1 and 0.

    Try this example

Common mistakes

STDEVA in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try STDEVA in the playground

Related functions