|
![](/i/fill.gif) |
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
|
![](/i/fill.gif) |