Created attachment 177401 [details] Screenshot from the bug within Calc. Dear developers, I found this bug in the German version of LibreOffice Calc, but I presume it will be the same in any other translation. Try this in Calc: Format A1 and A2 as text. Enter in A1: 5 Enter in A2: 5+ (i.e. necessary when entering school grades in Germany) Enter in A3: =ZÄHLENWENN(A1:A2;"5") means: =COUNTIF(...) The result will be: "2". The "+" in A2 is not being noticed by the program. When you open the file in MS Excel, the correct result "1" is displayed. Thank you for your great work, you are creating a fabulous program! Yours sincerely Overlord
Generally COUNTIF depends on what is selected at Options->LibreOffice->Calculate, General Calculations/Search criteria = and <> must apply to whole cells. However, until recently, there was bug 139612, fixed in 7.2.5. *** This bug has been marked as a duplicate of bug 139612 ***