Adding cell above with cell on the left

[Boguz]

Hey
I am REAAAAALLY new with excel and i actually have no idea how to achieve what i am looking for, even though i have the feeling it is not something very complicated.
Let me try to explain.

I would like a cell to add the cell above itself with the cell on it's left.
Ex: C3=C2+B3

But i would like that this would be applied to the whole column. And, if possible, if i would at some point insert a row in the middle that the rows under it would be updated.

Of course i could make it by hand, one by one, but is there a "general formula", kind of like:
if Row=X and Column=Y,
X,Y=(X-1,Y)+(X,Y-1)

Thanks guys, any help would be greatly appreciated!
=)

[darkyam]

If you select a cell and move your mouse to the bottom right corner, the cursor will become a black cross. Click and hold, then drag down as necessary and it will fill in the formula. You can also highlight the range, beginning with the cell that has the formula and hit Ctrl+D.

As to your formula itself, the trickiest part is getting it to recognize new rows, but that can be accomplished by putting this in C3: =Index(B:B,Row())+Index(C:C,Row()-1)

[Boguz]

hi

thank!!
i was sure there was a simple way to apply one formula so it "updates" the row and column numbers automatically, so THANK you for telling me about dragging.
I have manage to make it work with a normal sum (in C3 i have put =SUM(C2;B3) ), but when i tried the formula you gave me it says there is an error (which i have no idea how to fix!)

Once again, thanks! =)

[darkyam]

The formula works for me. The only difference I can see is that your version uses semicolons instead of commas. If it still doesn't work after trying this tweak, post the workbook, with dummy data if necessary, and we'll have a look at exactly what's happening.

[Boguz]

i think that was it. i changed the commas for semicolons and now it works.
i now have:
=INDEX(B:B;ROW())+INDEX(C:C;ROW()-1)

GREAT!!! Thank you very much! This will make things a lot smoother!
=)