Results 1 to 2 of 2

Thread: copy formula horizontally

  1. #1

    copy formula horizontally

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am stuck in copying formula horizontally, here what I want to do
    This is base file
    year 2015 tast1 tast2
    10000 .2 .6
    50000 .9 .1
    40000 .5 .5

    I want to create a file like this
    tast1 sumproduct of year 2015 and task1
    task2 sumproduct of year 2015 and task 2

    So here year range will remain constant but column will change. I am not able to do it .
    It would be a big help for me.


  2. #2




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts