VARA Function

Estimates variance from a sample, counting text and logical values.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice VARA in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

VARA works like VAR.S, but it doesn't skip text and logical values in a range.

The "A" versions count text and FALSE as 0 and TRUE as 1 when they sit in a range; empty cells are still ignored.

Syntax

=VARA(value1, [value2], …)

Arguments

ArgumentRequired?What it does
value1YesA value, cell or range from the sample.
value2, …NoUp to 254 more values, cells or ranges.

Examples

Example 1 — Variance with text as zero

Ben and Gus have text, Di is blank, and Fay scored 0.

E2fx=VARA(B2:B8)
ABCDE
1NameScoreMeasureResult
2Ana82VARA2103.47
3BenabsentVAR.S1769.67
4Cy91
5Di
6Ed77
7Fay0
8Guspending
=VARA(B2:B8) Explain

The square root of 2,103.47 is 45.86 — the STDEVA result.

Common mistakes

  • #DIV/0! Fewer than two values are counted.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.