https://bugs.documentfoundation.org/show_bug.cgi?id=154173
Eike Rathke <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #2 from Eike Rathke <[email protected]> --- You have regular expressions enabled in your document, where * asterisk and other characters are operators. Switch off under Tools -> Options -> Calc -> Calculate, Formulas Wildcards. In your case even no wildcards. Or instead, use the formula =SUMIF(A$1:A$240;"\Q"&H1&"\E";B$1:B$240) for a quoted sequence. See https://help.libreoffice.org/7.5/en-GB/text/scalc/01/func_sumifs.html?DbPAR=CALC#bm_id658066580665806 https://help.libreoffice.org/7.5/en-GB/text/shared/optionen/01060500.html?&DbPAR=CALC#bm_id3154420 -- You are receiving this mail because: You are the assignee for the bug.
