excel 2000: Cumulative addition 1

[add39]

How can I do a cumulative addition in excel? ie: the first entry would be 3.2 , the second one would be 3.2 + 3.9, the third one would be 3.2 +3.9+ 4.4...etc. There is no sequence to the numbers, it is just a cumulative sum of the previous column. Any easy way to do this without having to do each cell individually?

Thanks.

 

[bluedragon2]

I assume col A is the data:

In col B, row 1, put =sum(a1)
in row two, put =sum(A2+B1)
in row three, put =sum(A3+B2)

Highlite B2 and B3, click and hold the little black box on the lower right of the highlite box and drag down.

Blue

 

[mbarron]

The easiest way I know is illustrated below. Just drag the formula in column B

A        B (cumm)  (formula in column B)
2.3     2.3        [none]
3.5     5.8        =A2+B1
1.2     7.0        =A3+B2

Mike

 

[RRinTetons]

Assume data in column A, starting in row 1.

In B1 put SUM($A$1:A1)

Copy to the bottom of your range.

Note the $'s in the first reference to A1. These make the reference absolute - i.e. - it doesn/t change when copied. The other reference to A1 is a relative reference and it does change as copied. Therefore, cell B2 will have the formula SUM($A$1:A2), B3 will have SUM(A$1:A3), etc.)

Richard Ray
Jackson Hole Mtn Resort
Teton Village, WY

 

[mbarron]

Oops...

This

A        B (cumm)  (formula in column B)
2.3     2.3        [none]

should have been

A        B (cumm)  (formula in column B)
2.3     2.3        =A1

Mike

 

[bluedragon2]

LOL, that is what I meant mbarron, somehow my brain put the sum function in my typing without me knowing it...

 

[add39]

Thanks everyone! I used Richard's method w/the absolute references and it worked.