7 Replies Latest reply: Nov 2, 2015 3:53 AM by vishnu kashaboina RSS

    how to sum up data that arranged horizontally?

    Jim Chan

      Hi there,

       

      My client has given me data structure as such, in excel form:

      y1y2y3y4y5total
      1020304050150

       

      If I took out the "Total column" and leave the data as y1 until y5, how can i write an expression to sum up y1-y5 , with data in such format?

       

      Rgds

       

      Jim