202206291556总和 先求和 再求积 (10157)

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))

沒有上一則|日誌首頁|沒有下一則
回應
關鍵字
    沒有新回應!
    blank