Add two columns into third column in Gnumeric

3.5k Views Asked by At

Is there a way to add two columns cell by cell and from a third column? Think of the two columns as two arrays and third column as the sum of these two arrays.

How can I do this in gnumeric?

1

There are 1 best solutions below

0
On

Yes, it is possible. Suppose you want to add data from columns A and B and put the result in column C. Select column C (may be not the whole column though) and type: =A:A+B:B then validate using Ctrl+Shift+Enter

If you only need 10 rows, the formula would be =A1:A10+B1:B10