8 Replies Latest reply: Oct 16, 2014 5:11 AM by Cristian Ivanoff RSS

    RangeSum

      Hello,

       

      I have next example

      First column weeknr

      Second column number

      Third column RangeSum

       

      52     100     100

      51     150     250

      50     300     550

      49     100     650

      48     400     1050

      etc.

       

      I Have for third column next formula: RangeSum(Above(sum(BRUTO),0,rowno()))

       

      But I want to have next output

      52     100     1050

      51     150     950

      50     300     800

      49     100     550

      48     400     400

      etc.

      Also RangeSum in Reverse Order from what i now have.

      Weeknrs. should be in order as in example.

      Who can help me?

      Thx.