Created attachment 177401 [details]
Screenshot from the bug within Calc.
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!
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 ***