H18:K23=SUMPRODUCT(($G$2:$G$7=$B$10:$G$10)*$B11:$G11*MMULT($H$2:$K$7*(COLUMN(A1)>={1,2,3,4}),{1;1;1;1}))
另解{=SUM(($B$10:$G$10=$G$2:$G$7)*$B11:$G11*MMULT(OFFSET($H$2:$H$7,,,,MAX(COLUMN(A1))),TRANSPOSE(COLUMN($A:A))^0))
另解{=SUMPRODUCT($B11:$G11,TRANSPOSE(SUBTOTAL(9,OFFSET($H$1,ROW($1:$6),,,COLUMN(A1)))))
另解{=SUM(TRANSPOSE($B11:$G11)*MMULT($H$2:$K$7*(COLUMN(A1)>={1,2,3,4}),{1;1;1;1}))
另解{=SUM(TRANSPOSE($B11:$G11)*($H$2:H$7))
留言
張貼留言