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

Thank you!, easy to understand and straight to the point!

Please note a very significant drawback of this kind of functions. If “IF” function incorporates an equality to zero condition (i.e. “=0” or “=>0” or “==0)*(C:C<=20)*(C:C””),C:C,””))