Functions
STDEVA
Sample standard deviation including text and logical values
Try it
When to use it
When should I use STDEVA instead of STDEV.S?
Use STDEVA when your dataset may contain text or logical values (TRUE/FALSE) that should be counted — TRUE is treated as 1 and FALSE/text as 0 — whereas STDEV.S ignores non-numeric values entirely.
Used in
Syntax
STDEVA(value1,...)Examples
=STDEVA(1,2,3,4,5,6,7,8,9,10) // => 3.0276503540974917