Write in AY1:
=SUM(OFFSET(AR1,0,-MIN($AO1,COLUMN()-COLUMN($AY1)+1)
+1,1,MIN($AO1,COLUMN()-COLUMN($AY1)+1)))

and then copy to AZ1:BE1 and to AY2:BE9.

HTH,
sulprobil
--
Reverse(moc.liborplus.www)