Welcome to the board.

Row\Col
A
B
C
D
E
F
G
H
I
1
Name
Gender
Age
test
Gender
Age
Pctl
2
 Subject 01
M
10
6.693
M
14
6.328
 H2: {=PERCENTILE(IF(($B$2:$B$20 = F2) * ($C$2:$C$20 = G2), $D$2:$D$20), 0.1)}
3
 Subject 02
M
12
7.463
4
 Subject 03
M
15
5.208
5
 Subject 04
M
16
5.475
6
 Subject 05
M
18
5.600
7
 Subject 06
M
11
6.112
8
 Subject 07
M
15
6.154
9
 Subject 08
M
14
6.176
10
 Subject 09
F
14
6.259
11
 Subject 10
M
11
6.280
12
 Subject 11
M
11
6.377
13
 Subject 12
F
13
6.471
14
 Subject 13
F
15
6.550
15
 Subject 14
F
12
6.616
16
 Subject 15
M
12
6.792
17
 Subject 16
M
13
6.834
18
 Subject 17
M
14
6.934
19
 Subject 18
M
14
7.074
20
 Subject 19
M
13
7.114