Addition of cells from the same columns in different rows

maku · June 1, 2023, 4:13pm

Hello everybody.
I have a question concerning the addition of cells in LibreOffice Calc.
I have a spreadsheet with over 200 rows and need to add the values of cells in the same columns, but not everyone (e.g. B, D, F), for every row. I know that the formula for addition in LibreOffice Calc is “=SUM(B1,D1,F1)”, but is there some kind of “universal formula”, which allows me to add every cell in a row from the given columns, superseding all the typing for each row, correcting the afore mentioned formula to the specific row (e.g. =SUM(B1,D1,F1); =SUM(B2,D2,F2); =SUM(B3,D3,F3); etc.)?
Thank you in advance!
LG

Edit: Thank you all for helping me out!

karolus · June 1, 2023, 4:23pm

Hallo

=SUM(B1:B250;D1:D250;F1:F250)

maku · June 1, 2023, 4:41pm

Thank you, but that adds up all the cells from the given columns. Maybe my description was faulty.

Lets say I have a spread sheet with 10 rows and columns A to F.
I would need the sum of the values in the cells in lying in column B1, D1 and F1.
Next would be row two, where i need the sum of B2, D2 and F2 and so forth.

The question would be, if there is a formula, that says something like “add the cells in that row, that also lie in the columns B, D and F”, instead of typing “=SUM(Bx,Dx,Fx)” 10 times and having to replace x with the corresponding row each time.

karolus · June 1, 2023, 5:05pm

hallo
Start with:

=SUM(B1;D1;F1)

and pull down

JohnSUN · June 1, 2023, 5:07pm

Ah, that’s what you’re asking! Do you know about the purpose of this bold dot in the lower right corner of the active cell?

Move the cursor over it so that the image “arrow” changes to “cross” and double-click the left mouse button
FillDown

mariosv · June 1, 2023, 5:11pm

How about dragging the cell with the formula in the first row by the lower right edge, downwards?

erAck · June 1, 2023, 5:28pm

Or preselect the range, e.g. in the Name Box (Shift+Ctrl+T) type G1:G200 and hit Enter, then with the range still marked type =SUM(B1;D1;F1) and hit Alt+Enter to close. The formula will be distributed over the selected range and cell references adjusted like when pulling down a formula cell or copy-pasting.