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

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

=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)**

=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”:

=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”:

=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**.

**Related:** STDEV.P vs. STDEV.S in Excel: What’s the Difference?

**Additional Resources**

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

How to Calculate a Five Number Summary in Excel

How to Calculate the Mean and Standard Deviation in Excel

How to Calculate the Interquartile Range (IQR) in Excel