Try these formula in D2:G2, respectively:
=AND(SUMIF($B$2:$B$19,$B2,$C$2:$C$19) < 25, SUMIF($A$2:$A$19, $A2, $C$2:$C$19) > 100)+0
=AND(SUMIF($B$2:$B$19,$B2,$C$2:$C$19) < 25, SUMIF($A$2:$A$19, $A2, $C$2:$C$19) < 100)+0
=AND(MIN(IF($B$2:$B$19=$B2,$C$2:$C$19)) < 25, SUMIF($A$2:$A$19, $A2, $C$2:$C$19) > 100)+0
=AND(MIN(IF($B$2:$B$19=$B2,$C$2:$C$19)) < 25, SUMIF($A$2:$A$19, $A2, $C$2:$C$19) > 100)+0
note: the last 2 are array formulas and need to be confirmed with cTRL+SHIFT+ENTER not just ENTER... then copy each formula down.
Now, I am not sure why for the column F, you say that only the first X7 item should return a 1? Why not the second X7 item too? since there is only one Y16 and it is less than 25
Bookmarks