多區多組 取不重複 且計算總時間 (14394)

取不重複 B8{=INDIRECT(TEXT(MIN(IF((D$2:H$4<>"")*(MOD({1,2,3,4,5},2)=1)*(COUNTIF(B$7:B7,D$2:H$4)=0),{2;3;4}/1%+COLUMN(D:H),9999)),"!R0C00"),)&""

C8=IF(B8="","",SUMIF(D$2:H$4,B8,C$2:G$4))