https://bugs.documentfoundation.org/show_bug.cgi?id=157948
--- Comment #3 from Eike Rathke <er...@redhat.com> --- So what's the difference to B1: =SUM(OFFSET(A1;$E$1+1;0;-$E$1;1)) B2: =SUM(OFFSET(A2;$E$1+1;0;-$E$1;1)) ... B8: =SUM(OFFSET(A8;$E$1+1;0;-$E$1;1)) B9: =SUM(OFFSET(A9;$E$1+1;0;-$E$1;1)) ... ? Which IMHO makes it even clearer that an actual range is shifted. (except that Excel apparently displays #REF! error in B1:B6 instead of Err:502). In real one probably would enter 7 in E1 and instead use B1: =SUM(OFFSET(A1;-($E$1-1);0;$E$1;1)) ... -- You are receiving this mail because: You are the assignee for the bug.