Max Ifs Formula? is this possible

Hi

im trying to create a "MAX IFS" formula, and am currently using this....

Formula:

=IF(D41=4,0,IF(D29=2,0,MAX(if('High,Low,Avg'!$U:$U,'High,Low,Avg'!$D:$D,'Supply Chain Calculator'!$D$30,'High,Low,Avg'!$H:$H,'Supply Chain Calculator'!$D$38,'High,Low,Avg'!$B:$B,INDEX($A$230:$BI$230,,'Supply Chain Calculator'!$D$31):INDEX($A$230:$BI$230,,'Supply Chain Calculator'!$D$32))+D48)))

But this doesnt return the right value, is there a way to create a maxifs, like you would wth a SUMIFS?

Dan

for example
=MAX(IF(A1:A100="YES",B1:B100,0)*(IF(C1:C100="YES",1,0))
as an array formula, confirmed with ctrl+shift+enter

Hi, yes but it depends on multiple conditions

=max(if(a1:a100="yes",b1:b100,0)*(if(c1:c100="yes",1,0)*if(d1:d100="yes",1,0)*if(e1:e100="yes,1,0))

Ah right got you thank you

Thats perfect thank you very much!!!

I had just written out.....

Formula:

IF($D$41=4,0,IF($D$29=2,0,MAXif('High,Low,Avg'!D:D='Supply Chain Calculator'!D30),if('High,Low,Avg'!H:H='Supply Chain Calculator'!D38,'High,Low,Avg'!B:B,index('Supply Chain Calculator'!E230:BI230,,'Supply Chain Calculator'!D31):index('Supply Chain Calculator'!E230:BI230,,'Supply Chain Calculator'!D32,'High,Low,Avg'!U:U))))

But was a long way off being close to your formula.

Thanks again Dan

Yes thats right, i want to look at the max between two dates specifically so the dates are labelled by week numbers 1 through to 52, my index in cells a230 - bi230 is then 1-52, so hopefully it should only look at the max in that selection....

I will try your formula thank you

Sorry the week numbers are 57 long, i had to do it that way as its looks at two countrys which have different rates and different arrival dates so the common factor was week commencing, but looked at arrival date to figure that out,

The data starts from E sorry not A