Home > OS >  Percentile with multiple conditions in google sheets
Percentile with multiple conditions in google sheets

Time:10-02

I have a sheet called "main" with 4 columns like this : enter image description here

I want to make a percentile of column N, with condition of column A, C, and J

I tried with function PERCENTILE(IF((x)*(y)*(z),aa),0.5) and works for

queue_name = "idecbi-prod",

grass_week = "2022-09-05",

and task_user = "di_scheduler",

Desired Answer : enter image description here

it works just fine with these conditions,

But when I tried to use another condition such as "idecbi-dev" or "ad-hoc" or another grass_week, it become error like this

enter image description here

Whereas the only thing i change is only O4 to O5 and N4 to N5

The data seems fine and we have all the conditions as shown in the first picture (main sheet).

Is there anything that I miss ?

Here's dummy data that I've created for better understanding.

enter image description here

  • Related