=IF(AND(50-B3<=SUM(-IFERROR(SMALL(IF($B3:$G3<50,50-$B3:$G3,""),ROW(INDIRECT("1:"&MATCH(B3,LARGE(IF($B3:$G3<50,$B3:$G3,""),COLUMN($B3:$G3)-COLUMN($B3)+1),0)+SUM((B3=$B3:B3)*1,-2)))),0),10),B3<50),50,B3)

=IF(AND(50-B8<=SUM(-IFERROR(SMALL(IF($B8:$G8<50,50-$B8:$G8,""),ROW(INDIRECT("1:"&MATCH(B8,LARGE(IF($B8:$G8<50,$B8:$G8,""),COLUMN($B8:$G8)-COLUMN($B8)+1),0)+SUM(MATCH(MATCH(B$7,{"إنكليزي","رياضيات","فيزياء","كيمياء","عربي","إسلامية"},0),SMALL(IFERROR(MATCH(IF(B8=$B8:$G8,$B$7:$G$7),{"إنكليزي","رياضيات","فيزياء","كيمياء","عربي","إسلامية"},0),""),ROW(INDIRECT("1:"&SUM((B8=$B8:$G8)*1)))),0),-2)))),0),10),B8<50),50,B8)