https://bugs.documentfoundation.org/show_bug.cgi?id=170743
--- Comment #9 from ady <[email protected]> --- (In reply to clear from comment #8) > https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sumif.html > https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sumifs.html > > The authors mention these restrictions on Named Ranges for SUMIF, but do not > for SUMIFS. FWIW, <https://help.libreoffice.org/latest/en-US/text/scalc/01/func_sumifs.html> ...includes a link to the wiki page: <https://wiki.documentfoundation.org/Documentation/Calc_Functions/SUMIFS> ...which, at the time of writing this, includes the following phrase: "A reference to a cell range (for example, A1:A25), which may not utilize the reference concatenation operator (~)". As I mentioned before, the other specific functions that you attempted to use with a concatenation of ranges (which, in addition, are ranges located in different spreadsheets of the same workbook) have similar issues and these are documented in their respective wiki pages. Now, if any of these specific functions in Calc is not behaving according to the ODF standard (which is something that _can_ happen), then please feel free and encouraged to open a bug report for such inconsistency, with a relevant link to the specific ODF standard section and an ods minimal example. -- You are receiving this mail because: You are the assignee for the bug.
