Excel Formula help

Copper Contributor

Hi guys, I'm not sure if this is the right place to post this, but I'm a little desperate and I need help.

 

Essentially, I'm using formulae for my MSc work, and I require a formula that changes in every cell (it's hard to explain, but I'll try.)

 

E.g., in one cell (D38) I'm using "=sum(D37+C38), and then in the next cell (D39) "=sum(D38+C39)" and (D40) "=sum(D39+C40)". 

 

I need to enter a formula that will change in every cell, that will change the D37 to D38 in the next cell if possible, because this will save me hours and hours if not days of work.

 

Thank you.

2 Replies

Excel should more or less do this for you.. is D38 enter:

=SUM(C37:C38)

 

then with D38 selected, click and hold the square in the corner of the cell and drag down. Excel will copy the formula down and update it as you want.

another way is if you have continuous data in column C, you can save time to drag the formula till last row,

place cursor at D38, hover the mouse pointer at the lower-right corner of selected cell, when "+" sign appears, double click it.

You formula will be copied.