Add extra criteria into IF/MAXIF

[surkdidat]

Hopefully this is an easy one, but my brain is now so fizzled I cannot work out where in the formula I need to add what I need!

My current formula is

=IF(OR('DEV WIP'!C3="",SUM('DEV WIP'!$M3:$AB3)=0),"",
IFS(
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$AB3,'DEV WIP'!$AB$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$AA3,'DEV WIP'!$AA$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$Z3,'DEV WIP'!$Z$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$Y3,'DEV WIP'!$Y$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$R3,'DEV WIP'!$R$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$P3,'DEV WIP'!$P$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$O3,'DEV WIP'!$O$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$N3,'DEV WIP'!$N$1))

What I need to add is for the formula to only do return a result if, in column E the cell equals "YES"

 

[mole999]

try

=IF(E1="YES",IF(OR('DEV WIP'!C3="",SUM('DEV WIP'!$M3:$AB3)=0),"",
IFS(
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$AB3,'DEV WIP'!$AB$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$AA3,'DEV WIP'!$AA$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$Z3,'DEV WIP'!$Z$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$Y3,'DEV WIP'!$Y$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$R3,'DEV WIP'!$R$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$P3,'DEV WIP'!$P$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$O3,'DEV WIP'!$O$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$N3,'DEV WIP'!$N$1)),"")

 

[surkdidat]

Thank you - I was trying to imbed it into the code already written and not a separate statement. Easy from a fresh pair of eyes!

try

=IF(E1="YES",IF(OR('DEV WIP'!C3="",SUM('DEV WIP'!$M3:$AB3)=0),"",
IFS(
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$AB3,'DEV WIP'!$AB$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$AA3,'DEV WIP'!$AA$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$Z3,'DEV WIP'!$Z$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$Y3,'DEV WIP'!$Y$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$R3,'DEV WIP'!$R$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$P3,'DEV WIP'!$P$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$O3,'DEV WIP'!$O$1,
MAXIFS('DEV WIP'!$N3:$AB3,'DEV WIP'!$N3:$AB3,"<"&AH$2+7,'DEV WIP'!$N3:$AB3,">0")='DEV WIP'!$N3,'DEV WIP'!$N$1)),"")