Functions
VARA
Sample variance including text and logical values
Try it
When to use it
When should I use VARA instead of VAR.S?
Use VARA when your dataset may include text strings (counted as 0) or logical values (TRUE=1, FALSE=0) that should be included in the variance calculation — VAR.S ignores non-numeric cells entirely, while VARA counts them.
Used in
Syntax
VARA(value1,...)Examples
=VARA(1,2,3,4,5,6,7,8,9,10) // => 9.166666666666666
=VARA(2,4,4,4,5,5,7,9) // => 4.571428571428571