Description: In Column A I have a list of values containing strings such as "a (b)" or "b (c)" In column E I have a list containing each unique value in column A. Column D consists of this equation: =countifs(a:a,e1) in this case e1 contains a value from column A. The count is always zero. Steps to Reproduce: See description for required spreadsheet. Expected Results: Count of values Reproducible: Always User Profile Reset: No Additional Info: User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
Created attachment 129772 [details] Sample Spreadsheet Demonstrating Error
Tools > Options > LibreOffice Calc > Calculate Enable regular expressions in formulas is causing this. Set the radio button to somewhere else for a quick fix. For a more industrial-strength solution, check the file attached by Lupp in an answer to this: https://ask.libreoffice.org/en/question/33779/how-do-i-escape-a-cell-value-to-stop-it-being-treated-as-a-regular-expression/?answer=34614#post-id-34614 Closing.