對了,我用了沒函數
輸入數據沒動@@
29882245 發表於 21-6-2014 23:18 
沒函數?
F3
=SUM(B3+(C3*30)+(D3*10)+E3)
F4
=SUM(B4+(C4*30)+(D4*10)+E4)
以下
=SUM(B5+(C5*60)+(D5*10)+E5)
=SUM(B6+(C6*30)+(D6*10)+E6)
=SUM(B7+(C7*30)+(D7*10)+E7)
=SUM(B8+(C8*60)+(D8*10)+E8)
=SUM(B9+(C9*30)+(D9*10)+E9)
=SUM(B10+C10+E10)
D11:=SUM(510-(D3+D9+D4+D5+D6+D7+D8)) |