CODEWITHSUNDEEP
libreofficelibreoffice-calc
Razlo3p
Razlo3p

Reputation: 487

Sum 1 to n Libre Office

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!

Upvotes: 0

Views: 371

Answers (1)

Christian Fries
Christian Fries

Reputation: 16952

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

https://en.wikipedia.org/wiki/1_%2B_2_%2B_3_%2B_4_%2B_⋯

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.

Upvotes: 2

Related Questions