Hello
I have been trying to use that formula

=STDEV.S(IF('used data'!C:C="MALE";'used data'!U:U))

On 'used data'!C:C I have the gender, and on 'used data'!U:U I have the values I want to find the standard deviation. Apparently, the formula works fine if there are no blanks, but when there are blanks in the 'used data'!U:U column, if seems to include the blanks in the calculation (I have no blanks in the Gender column, and I tested it by removing the blanks on my values column manually).

Then, I have tried

=STDEV.S(IF(AND('used data'!U:U<>"";'used data'!C:C="MALE");'used data'!U:U))
=STDEV.S(IF(AND('used data'!U:U>0;'used data'!C:C="MALE");'used data'!U:U))

I have tried both with and without ctrl+shift+enter, to no avail.

Does anyone know how to solve this problem?

Best regards,
Diogo