https://bugs.documentfoundation.org/show_bug.cgi?id=170743
--- Comment #8 from clear <[email protected]> --- A discussion about documentation is off topic in the context of this bug report. I won't be replying again. OpenDocument 1) counsels "The definitions of specific ... functions ... stipulate any particular limitations there are on forms of references" 2) defines SUMIF as accepting ReferenceList|References 3) defines SUMIFS as accepting (only) References DocumentFoundation 1) defines SUMIF as "<condition> may utilize the reference concatenation operator" 2) defines SUMIFS as "may not utilize the reference concatenation operator" In the pages: 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. Granted that documentation is a popularization of the science, so it is entitled to some leeway, but the SUMIFS page needs some polishing to more accurately reflect the breakable aspects (restrictions) given in the technical definitions. Why SUMIFS can't handle ReferenceLists? I don't know. It seems all the code needs to do is loop through the areas as it does with functions. (I'm not asking for an explanation) Anyway, my apologies for creating a bug report about code when the code actually works as detailed in the more technical manuals. -- You are receiving this mail because: You are the assignee for the bug.
