Help with correlation command with conditions

[Simon93]

Hello, i would greatly appreciate any help!

My question is as follows:

I would like to find the correlation between being female, that is value=1 in column A, and answering >=11 in column C.

How can i do this? I don`t understand how to use the corrolation command with conditions. I`m right in thinking that if i want to find the correlation between being female and answering >=11 in column C, i should filter out all values that are equal to 0 in column A, and all values that are <11 in column C?

Thanks in advance!