You can use the following formulas to perform a standard deviation IF calculation in Google Sheets:

**Method 1: Standard Deviation IF (One Criteria)**

=ArrayFormula(STDEV(IF(A:A="Value",C:C)))

This formula calculates the standard deviation of values in column **C** where the values in column **A** are equal to “Value.”

**Method 2: Standard Deviation IF (Multiple Criteria)**

=ArrayFormula(STDEV(IF((A:A="Value1")*(B:B="Value2"),C:C,"")))

This formula calculates the standard deviation of values in column **C** where the values in column **A** are equal to “Value1” and the values in column **B** are equal to “Value2.”

The following examples show how to use each formula in practice.

**Example 1: Calculate Standard Deviation IF (One Criteria)**

We can use the following formula to calculate the standard deviation of the values in the **Points** column where the value in the **Team** column is equal to “Mavs”:

=ArrayFormula(STDEV(IF(A:A="Mavs",C:C)))

The following screenshot shows how to use this formula in practice:

The standard deviation of **Points** for the rows where **Team** is equal to “Mavs” is **7.3326**.

**Example 2: Calculate Standard Deviation IF (Multiple Criteria)**

We can use the following formula to calculate the standard deviation of the values in the **Points** column where the value in the **Team** column is equal to “Mavs” and the value in the **Position** column is equal to “Guard”:

=ArrayFormula(STDEV(IF((A:A="Mavs")*(B:B="Guard"),C:C,"")))

The following screenshot shows how to use this formula in practice:

The standard deviation of **Points** for the rows where **Team** is equal to “Mavs” and **Position** is equal to “Guard” is **5.5603**.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Calculate Standard Deviation in Google Sheets (Sample & Population)

How to Calculate Descriptive Statistics in Google Sheets

How to Calculate the Interquartile Range in Google Sheets