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.
精彩评论