1 Reply Latest reply: Jan 25, 2018 2:02 PM by Sunny Talwar RSS

    Using RangeSum??

    Prasad Mundewadi

      This is my table

      load * inline

      [A, B

      P,1

      Q,2

      R,3

      S,4

      T,5

      U,6

      V,7

      W,8

      X,9

      Y,10

      Z,11];

       

      I want to show a result like this in a table:

        

      A            BSum(below(B))
      P165
      Q263
      R360
      S456
      T551
      U645
      V738
      W830
      X921
      Y1011
      Z110

       

      the 3rd column is derived like this:

      e.g.

      for P (2+3+4....+11)

      for Q (3+4+5...+11) etc.

       

      How can I do this?