1 Reply Latest reply: Nov 4, 2017 3:17 PM by Massimo Grossi RSS

    How to add last 6 months which are in columns in excel file

    vijay mahajan

      Hi ,

      I have a excel file where I have months as headers and salaries of employees for 2017 as  sample data shown in the screenshot.source_table.png

      I have to get output as last six months salary of employees for 2017 as shown below

      output.png

       

      Each month we new month salaries updated so we have to get sum of last six months salary and this continues every month.

      Can anyone help me on this.

       

      Thanks in advance.