Sum two cells of one row into third cell in same row

[rbdavis808]

I need to sum two cells in each row of the table into a third cell in the same row. I want to do this for every row in the spreadsheet. If this was only a single row I would use a formula like =SUM(C2:D2) entered into that third cell of row 2 to sum the cells of row 2 columns C and D. How can I enter ONE formula ONE TIME ONLY and make this happen for every row in the table? I would like this to work in such a way that if I delete rows, add rows, or move rows up and down (i.e., change their row number), it will always work with no further changes.

Thanks!

[Villeroy]

@rbdavis808

=SUM(C2:D2)

Select the formula cell and ouble-click the cell handle (the tiny square in bottom-right corner. This will fill the formula along adjacent non-empty cells.
Alternatively drag the cell handle down.
Alternatively copy the formula cell, select the target range and paste.
Alternatively select the target cell and the target range and call menu::Sheet>Fill>Down.

Most fundamental spreadsheet knowledge since 40 years: Addresses and References, Absolute and Relative

[rbdavis808]

Thanks, Villeroy, all now working!

[EarnestAl]

You have to start somewhere so good on you. The Calc Guide and The Getting Started Guide are a free download from English documentation | LibreOffice Documentation - LibreOffice User Guides

[mikekaganski]

@rbdavis808

I would like this to work in such a way that if I delete rows, add rows, or move rows up and down (i.e., change their row number), it will always work with no further changes.

… that would likely need to use functions like OFFSET (volatile!). E.g., in C1 (note how it uses itself as the reference point):

=SUM(OFFSET(C1;0;-2;1;2))