Remote cell reference in formulae
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) ?
|