I'm looking for a function thats similar to factorial but does not build a product, but a sum.
So I have a cell with a number (in a big range) and I need to create a sum of the number and all numbers below it.
(function(12) would yield 78, function(3) would yield 6)
Several chained functions are fine as well. I'd like not to use macros or VBA as this needs to be transportable between several spreadsheet programs.