Forum Discussion
My OFFSET function is not working in excel2021
Do you have Office 365 or Excel for the web on computer A? In older versions OFFSET (or BEREICH.VERSCHIEBEN in german) only shows the value from the first cell.
Which result do you get for
=SUM(OFFSET(B2,0,0,3,1))
on computer B?
OliverScheurich Hi, thank you for your reply.
I don't have office 365 and excel for the web on computer A.
Both computers have LTSC 2021 version downloaded from the school.
I get the result of 6 for
=SUM(OFFSET(B2,0,0,3,1))
on computer B.
I think the function might be working correctly but just not displaying in an array format?
- ali88salujaAug 28, 2024Copper Contributor
- OliverScheurichAug 28, 2024Gold Contributor
In Excel for the web the formula spills the range. The screenshot in my earlier reply is from Excel 2013 where the range isn't spilled.
In my understanding the formula works correctly on both of your computers. But since you work with Excel 2021 on both computers i wonder why computer A spills the range.
- ali88salujaAug 28, 2024Copper Contributor
OliverScheurich
Thank you, I try running excel for the web version, and it worked successfully.
However, the drawback of the web version is that it cannot run macros.
I found that excel has the ability to spill the range since version 2019.
It works on my other computers, but computer B is the only one with this issue, which is why I'm so confused.