The VARA function is one of the statistical functions. It is used to analyze the set of values and calculate the sample variance.
VARA(value1, [value2], ...)
The VARA function has the following arguments:
Text and FALSE values are counted as 0, TRUE values are counted as 1, empty cells are ignored.
How to apply the VARA function.
The figure below displays the result returned by the VARA function.