送貨員計算繳交金額 (14596)

J2=SUMIF(C:C,I2,D:D)-SUMPRODUCT(COUNTIF(G:G,B$2:B$16)*D$2:D$16*(C$2:C$16=I2))



留言