8 Replies Latest reply: Mar 18, 2014 11:43 AM by Stefan Fischer RSS

    Calculate with values from 1 and 2 rows

    Stefan Fischer

      Hi,

       

      two values before columns needed. In column SU there are default values. Column average will be calculated with 12 values of SU in column average52. In row 1 and 2 there is the average of 12 values from SU. In Row3 i need the value of Row1 and also in Row2. How can I get this value for calculating at Row3

       

      Row1: (100  + 200  + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1.000 + 1.100 + 1.200) / 12 = 650

      Row2: (100  + 200  + 300 + 400 + 500 + 600 + 700 + 800 + 900 + 1.000 + 1.100 + 1.200) / 12 = 650

      Row3: Row1 and Row2 for calculation

      Row4: Row2 and Row3 for calculation

       

      Regards

      Stefan