5 Replies Latest reply: May 26, 2015 7:24 AM by Stefan Wühl RSS

    Running diminishing total in Straight table

    Brett Hull

      Hi All

       

      I am trying to calculate a diminishing total within a straight table based on a value as a starting point.

       

      The attached spreadsheet gives an example of what I want to do. I have tried using rangesum below and above.

       

      I can achieve this across the table but want it to calculate down. Not sure if this is possible to achieve.