加總 前50% (11423)

H1:H6{=IF(F1="","",SUM(N(OFFSET(C$1,RIGHT(LARGE(IF(A$2:A$11&B$2:B$11=LOOKUP("座",E$1:E1),D$2:D$11/1%+ROW($1:$10)),ROW(INDIRECT("1:"&ROUND(SUM(N(A$2:A$11&B$2:B$11=LOOKUP("座",E$1:E1)))*0.5,)))),2),F1=C$1))))