8 Replies Latest reply: May 25, 2017 7:39 AM by Sunny Talwar RSS

    RangeSum Starting at Zero

    Ryan Biggs

      Hi All

       

      Many thanks for the support on this one,

       

      I'm looking for a way to start a RangeSum Accumilation at Zero when the data range isn't zero at the original start point.

       

      For the attached Excel I can use RangeSum(Above(Return(Value),0,rowno())) to see the accumilation of totals which is great but If I needed that initial point to start at Zero (Without just writing 0 on the Excel sheet) is there a way to have the Rangesum start at Zero before starting the Ranged Sum please?

       

      MAny thanks