David

Many thanks for that tip - it is really neat. How come I have been
using Excel for so long and never seen it before? :)

Tim


Dave Peterson wrote in message ...
You could just adjust the formula:

With numbers in A1:A10 and the sum formula in A11:
=SUM(A1:OFFSET(A11,-1,0))

David McRitchie has some notes at:
http://www.mvps.org/dmcritchie/excel/offset.htm