Chambers wrote:
> So I have a certain function f(x), where x is a positive integer value.
> 
> I would like another function g(y) which is the sum of all values of f(x), with
> x ranging from 0..y
> 
> This is trivial using Sigma notation.  Unfortunately, this is not available in
> any spreadsheet I know of (I use MS Office at work, and OpenOffice.org at
> home).
> 
> 
> Does anyone here have an idea of how to calculate a sum this way?
> 

if for example, you have x values in a range C6:C7,
then you can use array functions (CTRL+Shift+Enter) like
=SUM(C4^C6:C7)

or, if there are not too many x values:

=SUM(C4^{1;2;3;4})

it can be used in both Excel and OpenOffice spreadsheets,
but check the list element delimiters.

Post a reply to this message