Dear Bernie
Thank you for your help, I'll see if I can make that work.
Regards
Graham

"Bernie Deitrick" wrote:

Put the 12 into cell A1, and use a formula like

=SUM(OFFSET(C5,0,0,$A$1-ROW(C5)+1,1))

HTH,
Bernie
MS Excel MVP


"Graham" wrote in message
...
Hi,
With a simple formula replicated over 12 columns, e.g. =SUM(C5:C10) can the
"C10" be referenced from a remote cell, whereby changing the value in the
remote cell to, say C12, will automatically adjust the formula in all 12
columns to recalculate as (C5:C12) to (N5:N12) ?