Standard deviation if "MALE" AND not blank

[Diogo2]

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

[shg]

=STDEV.S(IF((C:C = "MALE") * (U:U <> ""), U:U))

But I wouldn't use full-column references.

[Diogo2]

thank you VERY MUCH, I was going nuts!

Why is using full columns not recommended though?

[shg]

Why do a million calculations when you need a tiny fraction of that?