Customize offset
Hi,
I have offset in many cells but have the same direction i would like to change the offset in all cells same time
=SUM(OFFSET(Mapa.B1;6105-6;0;6;1))
i create cell C20 with reference value Mapa.B1 and change reference to:
=SUM(OFFSET(C20;6105-6;0;6;1))
but its not working i try the same with rows in cell C20 i put row number and change the formula to:
=SUM(OFFSET(Mapa.B1;C20-6;0;6;1))
not working, how i can easily change all offsets from all cells?
What do you mean by not working? Is there an error or just an unexpected SUM result?
i need one cell to control offset reference parameter for other one but when i put as reference value cell address its give me a 0 output
gives me output 1
but cell C20 as reference for formula