https://bugs.documentfoundation.org/show_bug.cgi?id=151046
--- Comment #4 from Sascha Nemecek <[email protected]> --- @Mike Kaganski: This is good thinking and could be the correct lead. My files used "UST2022", "UST2021" and so on as defined name ranges (JFTR: UST == VAT, value added tax). The formulas we use are build as follows: ``` =SUMPRODUCT( INDIRECT("Betrag"&AD$3-0&"Brutto"); INDIRECT("UST"&AD$3-0)=$C$97 ) ``` Explanatory information: * This will sum up all values for the given tax rate (e.g. 20%). * `AD$3` defines the year in question (e.g. 2022). * `$C$97` defines the tax rate we are looking for (e.g. 20%). * So `"Betrag"&AD$3-0&"Brutto"` resolves to `Betrag2022Brutto`, which is a named range referencing column cells in another sheet. The scope of the named range is set to the overview sheet. * `"UST"&AD$3-0` resolves to `UST2022`, which is a named range referencing column cells in the same sheet as `Betrag2022`. The scope of the named range is also set to the overview sheet. * JFTR: For better a understanding, I reduced the complexity of the formula. Additional information: When editing the names ranges ("Manage Names", <Strg>+<F3>), the dialog shows the following notice, when editing the "short" names, e.g. "UST2022": "Invalid name. Start with a letter, use only letters, numbers and underscore". As soon as I change the name to "UST_2022", the notice disappears and the formula is working again. That's why I assumed it's a minimum name length requirement. -- You are receiving this mail because: You are the assignee for the bug.
