My OFFSET function works correctly on Computer A, retrieving a 3x1 range of cells.
However, when I switch to Computer B, no matter what I do, it only retrieves the value of the reference cell, as shown in the attached image.
I have confirmed that both the version and settings are consistent.
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?
