Hi folks

I have gender in one column and age in second column. I need to find minimum
age for male patients, for female patients and maximum age as well. I tried
with IF function but it doesn't work

=IF(O3:O15="M";MIN(P3:P15)) in Q3 cell

O P Q
1 GENDER AGE MIN(M) MIN(F) MAX(M) MAX(F)
2
3 M 45
4 F 63
5 M 83
6 M 63
7 M 84
8 F 49
9 F 55
10 F 62
11 M 73
12 F 42
13 M 54
14 F 64
15 M 73

I think I'm on the right path but I need your help. Thanks in advance