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
| Argument | Required? | What it does |
|---|---|---|
| value1 | Yes | A value, cell or range from the sample. |
| value2, … | No | Up 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)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Name | Score | Measure | Result | |
| 2 | Ana | 82 | VARA | 2103.47 | |
| 3 | Ben | absent | VAR.S | 1769.67 | |
| 4 | Cy | 91 | |||
| 5 | Di | ||||
| 6 | Ed | 77 | |||
| 7 | Fay | 0 | |||
| 8 | Gus | pending |
=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

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.