On Mon, 19 Dec 2005 11:29:42 -0000, Bob Phillips wrote:

You could try

=SUM(OFFSET(B1,MAX(IF(ISBLANK($B$1:$B$65535),0,ROW ($B$1:$B$65535)))-10,0,10,
1))

which is an array formula, so commit with Ctrl-Shift-Enter

Thanks Bob. That works a treat.
Will go off and read up on array formulas now.


cheers