Wauvel

Excel like a finance pro.

← The library

Statistical function

STDEVA

Estimates sample standard deviation, counting text as 0 and TRUE as 1.

Rarely usedDifficulty 1250 · ProficientUsage rank #290 of 520
Practice · 2 questions →

When to use it

Sample standard deviation that counts text as 0 and logicals as 1 or 0.

The shape of it

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

Worked examples

  • Plain numbers

    =STDEVA(2,4,4,4,5,5,7,9) → 2.13808994

    Same as STDEV.S on plain numbers.

  • With a logical

    =STDEVA(1,2,TRUE) → 0.577350269

    TRUE counts as 1: the sd of 1, 2, 1.

  • With text

    =STDEVA(A2:A4) → 5.773502692

    A2:A4 holds 10, 0, and "n/a", where the text counts as 0.

Worth knowing

  • Use only when text placeholders should count as zero.
  • STDEV.S is the normal choice.
  • Blanks are still ignored.

Where it goes wrong

  • Text as 0 inflates the spread.
  • Numbers stored as text count as 0.

Related

AVERAGECOUNTCOUNTACOUNTIFCOUNTIFSMAX

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.