Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

There are always ways to spoil a formula by rather hidden details. Without your sheet at hand I will probably not find out.
The attached example works for me in LibO Calc. If it also works for you look at every single caharacter comparing my formula with yours and your second sheet name with mine.
(BTW: Avoid spaces in sheet names. A tiny but annoying complication! Trailing or additional spaces are easily missed, biut can spoiC:\fakepath\ask142967StrangeError_1.odsl everything.)

There are always ways to spoil a formula by rather hidden details. Without your sheet at hand I will probably not find out.
The attached example example works for me in LibO Calc. If it also works for you look at every single caharacter comparing my formula with yours and your second sheet name with mine.
(BTW: Avoid spaces in sheet names. A tiny but annoying complication! Trailing or additional spaces are easily missed, biut can spoiC:\fakepath\ask142967StrangeError_1.odsl spoil everything.)