總和 不規則累加 (13766)

G2{=SUMIF(B:B,"<="&F2,D:D)+INDEX((F2-C$2:C$5)*D$2:D$5/(C$2:C$5-B$2:B$5+1),MATCH(1=1,F2-C$2:C$5<=0,))



留言

張貼留言