Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Sum of a row of a named range

In LibreOffice Calc, how can I sum a row of a named range?

Assume I have a named range, foo, that looks like this:

1 2 3
4 5 6
7 8 9

I'd like to add another column with a sum each row in foo, like this:

1 2 3 | 6
4 5 6 | 15
7 8 9 | 24

Sum of a row of a named range

In LibreOffice Calc, how can I sum a row of a named range?

Assume I have a named range, foo, that looks like this:

1 2 3
4 5 6
7 8 9

I'd like to add another column with a sum each row in foo, like this:

1 2 3 | 6
4 5 6 | 15
7 8 9 | 24

I am looking for a way to do this only by referring to foo, and not directly to the cell locations.