Computing Percentiles for multiple conditions

Hi.

First of all, it's a disastrous idea to use entire column references within an array formula. With some functions, e.g. COUNTIF(S)/SUMIF(S), you can get away with referencing entire columns with no detriment to performance, though not with functions which operate over arrays, such as AGGREGATE, SUMPRODUCT, and any construction requiring CSE.

Try choosing a suitably large, though not too large, upper row reference, e.g. 100.

Secondly, you appear to be using OR in your attempts. Can you confirm that you want the formula to consider rows where either the entry in column B is "M" or the entry in column C is 14, and not those where both the entry in column B is "M" and the entry in column C is 14?

If the former:

=PERCENTILE(IF((B1:B100="M")+(C1:C100=14),F1:F100),0)

If the latter:

=PERCENTILE(IF(B1:B100="M",IF(C1:C100=14,F1:F100)),0)

both entered with CSE.

Regards

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