Sum 1 to n Libre Office

Question

there is a way (in open office calc) to have in a cell the result of the sum from 1 to N where N is the value of another cell?

I tryed to use Sum but this is not the thing i need!

score 2 · Accepted Answer · answered Jan 07 '16 at 12:14

You may use the formula n * (n+1) / 2.

The function sum is summing up the contents of cells, you may use sum if you have an array of n cells containing 1, 2, 3, ... n.

You may also write a macro / functions that does the sum.

1 Answers1