總和 三區域 不同順序 (11841)

K2:O6{=SUM(($A$2:$A$20=$J2)*N(+$B$2:$F$20)*(T(OFFSET($B$1,INT((ROW($1:$19)-1)/7)*7,{0,1,2,3,4}))=K$1))

另解{=SUM(IF(($A$2:$A$20=$J2)*(INDEX($B:$F,INT((ROW($2:$20)-1)/7)*7+1,N(IF({1},{1,2,3,4,5})))=K$1),$B$2:$F$20))