https://bugs.freedesktop.org/show_bug.cgi?id=76343
--- Comment #2 from Tom Dougherty <[email protected]> --- For numbers, the COUNTIF function should be in the format of =COUNTIF(range,criteria). For expressions and character strings, it should be in the format of =COUNTIF(range,"criteria"). When inserting via the function wizard, it is formatted as =COUNTIF(range,'criteria'). So for instance, if in cells A1-A3, we have Alice, Bob, and Carol, respectively, and we want to find how many times Alice occurs, we'd use =COUNTIF(A1:A3,"Alice"), which would return 1. If you at any point don't surround a literal text string criteria in the COUNTIF function with double quotes (for instance, if we had just used =COUNTIF(A1:A3,Alice) above), the text string is surrounded by single quotes (so =COUNTIF(A1:A3,'Alice'), which produces the incorrect results. Not sure why it would ever be using single quotes, as numbers don't need to be surrounded by anything, and character strings and expressions need to always be surrounded by double quotes. This seems to also be a problem in documentation; while the help file tells you that you need the double quotes, the function wizard itself does not. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
