Cumulative sum in the same cell

[itsrahulk]

Hi,

I have this data and i want to calculate the cumulative sum from this cells

i want the sum in the same cell k and add it to the previous available value in cell k like k = 30 + 23 = 53 and display 53 in place of 30 similarly k = 100 + 4 =104 in the same cell k as 104 in place of 100.


Please help.


Thanks

[millz]

1) Select the cells containing 23 and 4
2) Copy
3) Select the cells containing 30 and 100
4) Right click, Paste Special... under Operation, choose Add, click OK

[Marc L]

Hi,

if a VBA procedure is really necessary as it depends on how smart is your worksheet design so attach a sample workbook like explained in the top page yellow banner …

[itsrahulk]

It Worked Thanks