copy formula horizontally

[vipasha]

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

<tbody>
</tbody>

I want to create a file like this

	dept1
tast1	sumproduct of year 2015 and task1
task2	sumproduct of year 2015 and task 2

<tbody>
</tbody>

So here year range will remain constant but column will change. I am not able to do it .
Please help me.

Regards,

 

[dermie_72]

if you put $ to the left of the column that you do not want to change, and leave the changing columns as is, it should fix the issue.

IE. IF you do not want column A to change, but you want column B to move right.
=column($A:$A),column(B:B).

hope that helps.