Percentile calculation with 2 conditions

Hello hello,

I'm torturing my brain for hours now, trying to calculate Percentile from an excel list, with 2 conditions.
I made it work with a single condition, but no way to find the trick when there're 2..

I have actually a table of +1000 lines and I'd need to get the 20/50/80 percentile from it (column D - case_quality).

The thing is, I need to get those percentile for each different occurrence in Column B (Partner) AND by week (column C).

id partner week case_quality
30 ourselves 15 100
36 Partner 2 15 100
46 Partner 2 16 100
439 ourselves 16 65
440 ourselves 17 100
...

It works when I use only 1 condition, like here :
{=PERCENTILE(IF(datas!$B$2:$B$1146="ourselves";datas!$D$2:$D$1146);20%)}


but I can't get it with 2 condition.. the closest I've been (meaning, getting no error back) is the following formula but it only returns me 0 :
{=PERCENTILE(IF(AND(datas!$B$2:$B$1146="ourselves";datas!$C$2:$C$1146="17");datas!$D$2:$D$1146);20%)}

Any idea what I'm actually doing wrong ?

Thanks in advance for the little help,
regards from Switzerland

steve

Hi Sgh,

Thanks for your reply, your 2nd proposition (D13 & down..) seems to work as I needed it. So Thank you !

But I've to admit I can't understand it as I really didn't know that there were another usage for * (asterisk) than multiplication..
I've found many formulas using asterisk by searching for the Percentile but searching google didn't allow me to get relevant informations on its usage.. and I still don't get its purpose..
Does it simply work like an AND within the IF formula ?

Thank you,
And excuse my self-educated english..