總分500 不用總分欄 判斷達成少於33%與排名 (13814)

H4=SUMPRODUCT(N(MMULT(C$4:G$10,{1;1;1;1;1})>SUM(C4:G4)))+1

I4=IF(SUM(C4:G4)/1%/500>=33,"Pass","Fa1l")