Variable Cell Referenct

[Garforth Mike]

Hi
I am using offset to add the last 4 cells, however i want to use a previously calculated cell reference in the offset formula replacing G1 with the return in say F16 example F16 is a calculated cell ref using week number to say which cell to count back from.
.
=SUM(OFFSET(G1,0,-4,1,4))

I want to change G1 to whatever is showing in F16 EXAMPLE L1

[Andy Pope]

=sum(offset(indirect(f16),0,-4,1,4))

[Garforth Mike]

Thanks for very quick response, i have tried this but get a #REF failure, perhaps because F16 is itself a calculated return. F16 uses week number to determine which field to offset from.
so f16 is returning say H1

[Andy Pope]

you need to post example workbook. for me it works if F16 contain L1 or a formula resulting in H1

[Garforth Mike]

Sorry it does work, i wrote down wrong box,
Many thanks for quick response and helpful advice.
Saved my Sunday Afternoon.