Cumulative sums

I have data A1:A100 and i want B1:B100 to be for cumulative sums.i.e B1=A1,B2=A1+A2,B3=A1+A2+A3... etc .Anybody with a formular i can put in column B to do that?

Hi,

In B1 put = A1
In B2 put = B1 + A2
Then grab the lower right corner handle of B2 and pull it down.

See http://www.jegsworks.com/Lessons/num...tofilldata.htm

Hi Kipronpaul,

On B1 put a formula = a1
and now in b2 =A2+B1 and drag down, see attached:-

cummulative sum.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

Just to to show the different options in Excel.
You can also use =SUM(A$1:A1), in cell B1. $ lock's the formula to row 1, if you copy it up or down.
If you would use $A$1 it would also lock the formula from moving left/right.
//Ola