STDEVA

Calculates the standard deviation based on a sample, setting text to the value `0`. Learn more

Video field
Statistical

In Google Sheets, the STDEVA function is used to calculate the standard deviation of a set of values, taking into account text, logical values, and numbers as arguments.

The syntax for the STDEVA function is as follows:

STDEVA(value1, [value2, …])

value1: The first value or range of values to include in the standard deviation calculation.

value2, …: Additional values or ranges of values to include in the standard deviation calculation. You can include up to 255 arguments.

The STDEVA function calculates the standard deviation of the provided values, treating text and logical values as 0 and including them in the calculation.

It is useful when you have a range of values that may contain non-numeric data, such as text labels or logical values (TRUE/FALSE), and you want to calculate the standard deviation while ignoring these non-numeric values.

Here's an example to illustrate its usage:

=STDEVA(A1:A5)

This formula calculates the standard deviation of the values in cells A1 to A5, considering any text or logical values in those cells as 0 for the calculation.

Note that if you want to exclude non-numeric values from the standard deviation calculation, you can use the STDEV function instead.

The STDEV function ignores text and logical values while calculating the standard deviation.

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes no code required!