VARA function
VARA estimates the variance based on a sample. In addition to numbers, text and logical values such as TRUE and FALSE are included.
Syntax
VARA (value 1, value 2, ... value 30)
value 1, value 2, ...value 30 are values or ranges representing a sample of an entire population. The value arguments that contain TRUE evaluate as 1; arguments that contain text or FALSE evaluate as 0 (zero).
Note: If the data represents
the entire population, use VARPA to compute the variance. If logical
values or text must not be included, use VAR instead.
Example
=VARA(A1:A50)