Zoho Sheet STDEVA: Sample Standard Deviation, Syntax & Examples

STDEVA measures sample spread after treating TRUE as 1 and FALSE and text as 0. It is not interchangeable with STDEV when cells contain flags or descriptive text.

Use STDEVA for a sampled series when you have explicitly chosen to convert nonnumeric statuses to numerical zero rather than ignore them. For example, a quality analyst may have a sample of recorded fulfilment events where the analyst has independently confirmed that the status codes legitimately represent zero units. Do not quietly treat an exception message such as “Hold” as a real zero sale.

The sample formula uses n − 1 in the denominator, because the recorded observations stand in for a broader group. That degrees-of-freedom adjustment matters most for small samples. The square root converts squared deviations back to the original unit.

Because STDEVA returns a standard deviation, its value is expressed in the original unit. For the input vector below the independently computed expectation is 6.501373481 units. A variance and a standard deviation are related but not interchangeable. Reporting a variance as an ordinary “unit difference” would be a measurement error. A larger value indicates greater spread, not necessarily lower quality, and an individual result cannot determine whether a process is healthy without appropriate context.

STDEVA(number; [number1]; ...)

• number — required. Zoho describes this as the primary value, dataset, cell range or array for the sample being evaluated. Typical input is B2:B9, or a defined range whose name actually exists in the workbook.
• number1 and subsequent values — optional. Additional values, ranges or references may be provided. Zoho writes semicolons between arguments and uses ellipsis for further values; it does not establish a maximum count on this individual reference page.
• No separate mode parameter. STDEVA always uses the sample denominator, n − 1, for the mathematical convention covered here. For the other convention use STDEVPA (whose text/boolean policy should be verified separately).

Zoho’s vendor help expressly states that TRUE is counted as 1, FALSE is counted as 0, and any text value is counted as 0 for STDEVA. That is the main reason this function is different from a purely numerical analysis. The rule is a documented description, not a record of our own workbook test. Avoid assuming that a blank cell, a formula returning an empty string, or a formula error has exactly the same effect as a text label; this help page does not separately resolve those cases.

The examples here follow Zoho’s semicolon convention. Excel and Google Sheets commonly display comma-separated expressions in English-language help, and local language or delimiter settings can differ. Use the exact syntax presented by your own application when you paste a formula.

Enter these eight rows starting at A1, with the first row containing headers. Enter logical values as actual TRUE/FALSE booleans, not quoted text. Put Hold in B7 as text. Do not extend the formula into B10, which is intentionally outside the example input range.

The last column describes a documented conversion model, not extra data entered in column B. In a real business dashboard, Hold may mean a missing observation rather than zero; this example is intentionally designed to make that danger visible. On CSV import, a quoted TRUE value may import as text depending on import settings; confirm its spreadsheet type and re-enter it as a logical cell if needed.

Reproduce the mathematical expectation by hand

1. Convert the mixed sample to the eight numeric values 8, 10, 12, 1, 0, 0, 14, 16 according to the stated documentation rule. This is a calculation model—not a claim that a Zoho workbook has been executed.
2. Add the values: 8 + 10 + 12 + 1 + 0 + 0 + 14 + 16 = 61. Divide by eight to obtain the mean 7.625.
3. Calculate the squared deviations from the mean. Their sum is 295.875. As a cross-check, the sum of squares is 761 and 761 − 61²/8 = 295.875.
4. Because this is a sample, divide 295.875 by 7, yielding 42.267857143 in squared units before taking the square root.
5. For standard deviation, take the positive square root: 6.501373481 units.

This independent calculation provides a strong arithmetic check; it cannot establish Zoho’s live type coercion, interpolation, date formatting, locale settings or error handling. Results are rounded to nine decimal places for display.

Example 1 — use the mixed worksheet range.

1. Type the table exactly as shown, with B2:B9 containing eight entries.
2. Select an empty calculation cell, such as D2.
3. Enter =STDEVA(B2:B9) and submit the formula in Zoho Sheet when you are performing your own validation.
4. Compare its displayed value with 6.501373481 (independently calculated expectation). The cell might show fewer decimals due to number formatting; that does not necessarily indicate a different stored value.
5. If the value differs, first examine logical-cell types, locale conventions and whether Hold has been coerced or excluded. Record the observed result rather than silently editing the guide to match a guess.

Example 2 — numeric-only arguments. Enter =STDEVA(4;6;8;10). Those four arguments are 4, 6, 8 and 10, with mean 7. Their squared deviations sum to 20. The mathematical expected result is 2.581988897. The expression is useful for identifying whether a discrepancy comes from mixed-type cells rather than the core calculation.

Example 3 — direct logical arguments. Enter =STDEVA(TRUE;FALSE;8;10). The documented conversion rule gives the vector [1, 0, 8, 10] with mean 4.75 and squared-deviation sum 74.75. The independently calculated expected result is 4.991659711. Direct logical arguments and logical references may be handled differently in some spreadsheet products; this exact distinction has not been tested in Zoho, so this is a diagnostic case rather than a confirmed screenshot result.

Example 4 — compare with the numeric-only subset. Place the clean numerical observations 8,10,12,14,16 in E2:E6 and enter =STDEVA(E2:E6). The expected result is 3.162277660. This does not mean one output is “right” and the other “wrong”: the inputs represent different populations or samples. Name the intended cohort before choosing which to report.

Build a small quality-control audit with raw input in B2:B9 and a deliberately normalized numeric audit column C2:C9. Enter 8, 10, 12, 1, 0, 0, 14, 16 into C2:C9 only after reviewing the meanings of the source statuses. Calculate =STDEV(C2:C9) and compare that number with =STDEVA(B2:B9). Under the documented text/boolean conversion rule the independently computed expectation is 6.501373481 for each. Equality of those outputs is a testable expectation, not a native Zoho result.

To avoid hidden business assumptions, add D2:D9 as a separate exception-description column (for example, manual hold, not an actual zero). Do not use STDEVA on B2:B9 as the final KPI when any text means unknown, cancelled, or not yet measured. Instead clean or classify records before choosing a statistical function. This changes the business meaning of the numerator and the sample size; it is not just a formatting issue.

A useful sanity check is =STDEVA(4;6;8;10) with an independently calculated expectation of 2.581988897. The function does not need a text value to work: numerical samples are valid inputs, too.

Important edge cases: The closely related STDEVP reference describes coercion of flags despite having a numeric-only headline. That documentation ambiguity is why this guide states only the positive text/flag rule directly published on the STDEVA page, and does not claim that every competing function behaves differently on all platforms. The individual Zoho help article does not specify a first-supported version, maximum argument count, full mobile/desktop parity table, numeric precision policy, or detailed handling of empty cells versus empty-text formulas. Those cannot be asserted without further official evidence or testing. Exact behavior for all-blank ranges, numeric-looking text, errors inside a range, repeated cell references, or "" results requires a documented native test. A legitimate user may have all of these in the same operational workbook.

For a quick practical diagnosis, first try the four-number expression in Example 2. Then compare the result with the normalized numeric vector and finally reintroduce TRUE, FALSE and Hold individually. This reveals which input assumption is responsible for a difference. Never replace the source data with the normalized column unless the owner has approved that transformation.

• Zoho Sheet: STDEVA has the vendor syntax shown above. STDEV ignores text and logical values in cell ranges according to Zoho’s help, whereas STDEVA documents coercing them to zero/one. This can change both the mean and the number of observations; the difference should be deliberate, not accidental.
• Microsoft Excel: Microsoft documents STDEVA for compatible Excel products, typically with comma-separated arguments. Its help for related A-family functions distinguishes direct values from data in referenced arrays, and some pages appear internally inconsistent about including referenced text. Preserve a tiny comparison workbook instead of asserting identical cross-app mixed-type outcomes. Excel also offers the newer descriptive names STDEV.S, STDEV.P, VAR.S and VAR.P for numerical-only workflows, which do not simply replace the A-family inclusion rule.
• Google Sheets: Google publishes STDEVA as a function that treats text as zero. Its help uses commas in English examples and documents its own handling for minimum sample sizes. Do not assume that these support pages establish Zoho’s historical version support or platform behaviour.
• Numeric-only alternative: Choose STDEV when text and logical flags should not contribute in the same way. For a normalized, clean numeric column, choose that function or its explicit sample/population successor as appropriate.

Related guides: VARA, STDEV, STDEVPA.

• Vendor documentation check date: 2026-10-12. Official STDEVA reference: STDEVA — Zoho Sheet Help. Also reviewed the official Zoho statistical-function index.
• Cross-software documentation: Microsoft Excel STDEVA official function guide and Microsoft Excel VARPA official function guide (the relevant A-family principles; verify any other related function separately); Google Sheets STDEVA official function guide.
• Platform / version: The official Zoho reference confirms the function is documented for Zoho Sheet at check time. It does not provide a first-supported release date or a matrix proving matching behaviour for web, mobile, Windows desktop beta and macOS desktop beta. Therefore no historical availability year, universal desktop parity claim or verified offline behaviour is asserted here.
• Validation status: Official vendor documentation researched; supplied numeric examples calculated independently in Python; independent arithmetic tests passed; native Zoho Sheet executions 0; screenshots none.