Hello,
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
dept1
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.

Regards,