Quartile if basen on multiple variable criteria (3-7 out of 100)

Hi,

I am calculating quartiles based on the presence of multiple criteria. The number of criteria depends on the specific situation but may run from 3 to max 10 but can be chosen out of 100(!!)

The formula works well:

PERCENTIEL.EXC(ALS(INDIRECT($A$3)INDIRECT($B$3))=$K$3;ALS(INDIRECT($A$6)INDIRECT($B$6))=$K$6;ALS(INDIRECT($A$4)INDIRECT($B$4))=$K$4;ALS(INDIRECT($A$5)INDIRECT($B$5))=$K$5;ALS(INDIRECT($A$7)INDIRECT($B$7))=$K$7;ALS(INDIRECT($A$8)INDIRECT($B$8))=$K$8;INDIRECT($A16)INDIRECT($B16))))))));N$1)/1000000
But now:
I want to eliminate conditions out K5 and K7 automatically. I don’t know how!
Could you help?

Thanks a lot,

Amonia