K2:O6{=SUM(($A$2:$A$16=$J2)*N(+$B$2:$F$16)*(T(OFFSET($A$1,LOOKUP(ROW($1:$15),ROW($1:$16)/ISERR(-$B$1:$B$15),ROW($1:$15))-1,{1,2,3,4,5}))=K$1))
另解{=SUM(($A$2:$A$20=$J2)*N(+$B$2:$F$20)*(T(OFFSET($A$1,LOOKUP(ROW($1:$19),ROW($1:$19)/($A$1:$A$19="ID"),ROW($1:$19))-1,{1,2,3,4,5}))=K$1))
另解{=SUM(IF(($A$1:$A$19=$J2)*(INDEX($B:$F,N(IF({1},LOOKUP(ROW($1:$19),IF($A$1:$A$19="ID",ROW($1:$19))))),N(IF({1},COLUMN($A:$E))))=K$1),$B$1:$F$19))
另解{=SUM(($A$2:$A$20=$J2)*N(+$B$2:$F$20)*(T(OFFSET($A$1,LOOKUP(ROW($1:$19),IF($A$1:$A$19="ID",ROW($1:$19)))-1,{1,2,3,4,5}))=K$1))
留言
張貼留言