Aggregate with OR argument within

[fixmagic]

Hello everyone,

What is working:
25th Percentile for 1 criteria -AGGREGATE(18,6,$C$1:$C$10/($B$1:$B$10="Green"),0.25)
25th Percentile for 2 criteria - AGGREGATE(18,6,$C$1:$C$10/(($B$1:$B$10="Green")*($A$1:$A$10="January")),0.25)


What I am trying to do:
Select January or March for the month

25th Percentile for 2 criteria with an OR
AGGREGATE(18,6,$C$1:$C$10/(($B$1:$B$10="Green")*OR($A$1:$A$10="January",$A$1:$A$10="March")),0.25)
That formula does not work.

I tried a few variants with and without the OR but never got it to work.

Thank you for your help.

 

[Marcelo Branco]

Welcome to Mr Excel forum

To use an OR condition in an array formula you should add the conditions. See if this does what you need
=AGGREGATE(18,6,$C$1:$C$10/(($B$1:$B$10="Green")*(($A$1:$A$10="January")+($A$1:$A$10="March"))),0.25)

Hope this helps

M.

 

[fixmagic]

Thank you so much for your help.

It does indeed work. Fantastic.