开发者

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

开发者 https://www.devze.com 2023-02-17 08:09 出处:网络
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, bu

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

精彩评论

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