开发者

To calculate sum of c(1) + ... + c(i) in excel

I have one c开发者_StackOverflow中文版olumn, say c. I want to have a new column with value d(i) = c(1) + ... + c(i - 1) + c(i). Is it possible in Excel?


It's been a while since I used a spreadsheet, but something like:

    C     D
1         =SUM($C$1:C1)
2
3

And then you drag the cell with the sum formula down with the crosshair. The cell C1 will be fixed but the second "argument" will increase.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜