I have a LibreOffice Spreadsheet and I want to create a sum over values in a different tab. So the following content does work and gives me as result the number 176:
=SUM(Time2025.V4:V34)
However, when I try to do the same with indirect cells I use the cell content
=SUM(INDIRECT("Time2025.V"&D6&":V"&E6))
or
=SUM(INDIRECT("'Time2025'.V"&D6&":V"&E6))
it gives me a #ref error. The cells D6 and E6 do exist and contain the values 4 and 34, respectively (and are numbers).
So what can I try to fix this issue?
I have a LibreOffice Spreadsheet and I want to create a sum over values in a different tab. So the following content does work and gives me as result the number 176:
=SUM(Time2025.V4:V34)
However, when I try to do the same with indirect cells I use the cell content
=SUM(INDIRECT("Time2025.V"&D6&":V"&E6))
or
=SUM(INDIRECT("'Time2025'.V"&D6&":V"&E6))
it gives me a #ref error. The cells D6 and E6 do exist and contain the values 4 and 34, respectively (and are numbers).
So what can I try to fix this issue?
Share Improve this question edited Jan 20 at 11:47 Mark Rotteveel 109k226 gold badges155 silver badges219 bronze badges asked Jan 20 at 10:43 AlexAlex 44.3k100 gold badges298 silver badges513 bronze badges1 Answer
Reset to default 1The solution is to use an exclamation mark (!)as sheet name separator. So
=SUM(INDIRECT("Time2025!V" & D6 & ":V" & E6))
does, in fact, work! But if you have no indirect reference you have to use the dot (.) as sheet name separator.
=SUM(Time2025.V4:V34)
Using the exclamation mark here would lead to an error. Not intuitive at all ...