Solved this problem myself----


=OFFSET([book1]Sheet1!$A$1,month*26-26,0)+OFFSET([book1]Sheet1!$A$2,month*26-26,0)

When I assign the month cell to 1 for January, I'll get A1+A2 then in
February month =2 so I'll have A27+A28


Is there a better way?


--
Jean
------------------------------------------------------------------------
Jean's Profile: http://www.excelforum.com/member.php...o&userid=17585
View this thread: http://www.excelforum.com/showthread...hreadid=508575