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?