'Excel Stdev.S with If statement

I am trying to get the STDEV of the values that are higher than 10. The problem is that I am getting 0 as a value this is the formula I am using. =STDEV.S(IF(R2:R4723>T2; R2:R4723)). Anyone has an idea what I am doing wrong?

enter image description here

If I drag it down I get a number but the value that formule select is NULL. enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source