https://bugs.documentfoundation.org/show_bug.cgi?id=170743
ady <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #5 from ady <[email protected]> --- The specific functions that are used in sheet4 of attachment 205482, when they result in some error, cannot be used in those specific ways. In other ways, the resulting errors are correct. These specific functions require different syntaxes for the cases you are trying to evaluate. Just as one example, SUMIF() accepts the concatenation operator for the first argument, but only if the third argument is not used. So, in sheet4, cell A17, the formula: =SUMIF( tB; "=1"; tA ) ...is not accepted, because the third argument is being used while the first argument uses the concatenation operator. You could use – but I'm not saying that it is equivalent to what you tried to do – for example, an expression such as: =SUMIF( tB; "=1") ...which does not have the third argument in SUMIF(). Again, this is just a generic example; it does not mean that it is equivalent to what you tried to do, but rather just to show the accepted syntax when using the concatenation operator in this specific function. You can review the other functions in their respective wiki pages, and you will find similar issues. If you want to achieve some specific result and you don't find some adequate formula to do it, please try posting the question at <https://ask.libreoffice.org>. This is not a bug. -- You are receiving this mail because: You are the assignee for the bug.
