copy formula horizontally

vipasha

New member
Joined
Aug 28, 2014
Messages
1
Reaction score
0
Points
0
Hello,
I am stuck in copying formula horizontally, here what I want to do
This is base file
year 2015tast1tast2
10000.2.6
50000.9.1
40000.5.5


I want to create a file like this
dept1
tast1sumproduct of year 2015 and task1
task2sumproduct 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,
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Try

=INDEX($B$1:$C$1,1,MOD(ROW(A2),2)+1)

and

=INDEX(A:A,INT(ROW(A2)/2)+1)*INDEX(B:C,INT(ROW(A2)/2)+1,MOD(ROW(A2),2)+1)
 
Top