mardi 26 juin 2018

Extract Rows of Data that meets multiple criteria then get Percentile of the values

I have a raw data that contains the following structure

enter image description here

There are essentially two things I want to do in a formula: 1) Extract rows that contains Route=2 (cell G1), Direction=North (cell G2, Segment=14_15 (cell G3) 2) Get the 0.5 percentile of the values in those extracted rows.

Based on that logic I have written:

=PERCENTILE.INC(IF(AND(CT_Query!$A:$A=G1, CT_Query!$B:$B=G2, $C:$C=G3), $E:$E), 0.5)

After I pressed CSE, I got value 0.

Can anyone help tell me what went wrong?

Thanks a lot in advance for your help!

Aucun commentaire:

Enregistrer un commentaire