202210021937階段區計金额 後加總 (10562)

H2{=SUM(FREQUENCY(ROW(INDIRECT("1:"&B3)),SUBTOTAL(9,OFFSET(D3,,,,{1,2})))*(0&TRANSPOSE(SUBSTITUTE(D$2:F$2,"元",))))

另解=SUM(TEXT(B3+MMULT(-D3:F3,{0,1,1;0,0,1;0,0,0}),"0;!0")*{30,20,30})

另解=SUM(TEXT(B3-SUMIF(OFFSET(C3,,,,{1,2,3}),">0"),"0;!0")*{30,20,30})

可更改 D2:F2{=SUM(TEXT(B3-SUMIF(OFFSET(C3,,,,{1,2,3}),">0"),"0;!0")*(SUBSTITUTE(D$2:F$2,"元",)-(0&SUBSTITUTE(C$2:E$2,"元",))))

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