Help for the COUNTIFS function [1] states that the function "returns the count of rows or columns" - there should be "count of cells" instead. The reason is not obvious from the presented examples, because they deal only with data ranges spanning one column of a sheet. If the first example is changed from =COUNTIFS(B2:B6;">=20") to =COUNTIFS(B2:C6;">=20"), then the result will be 7 which does not relate to rows nor columns. Maybe - having now the possibility to add example files - would be useful to add such a file with more examples. [1] https://help.libreoffice.org/latest/en-US/text/scalc/01/func_countifs.html
Do you mind to attach here the example file for the case?
Created attachment 140955 [details] example of COUNTIFS This is a simple illustration of the fact that COUNTIFS returns number of cells. It is the example from the help page, modified to use more columns as input data.
Olivier Hallot committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=185624ce2dfea227f0357e417bb3615e88c95e8e tdf#116642 Fix COUNTIFS page + help makefiles
Olivier Hallot committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/help/commit/?id=b574fd22322fd31db2da408729cdd1c402626524&h=libreoffice-6-1 tdf#116642 Fix COUNTIFS page + help makefiles
A polite ping to Olivier Hallot: Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing? Thanks
From my - reporter's - point of view the bug is now fixed. Thank you, Olivier!
(In reply to Stanislav Horacek from comment #6) > From my - reporter's - point of view the bug is now fixed. Thank you, > Olivier! Closing as RESOLVED FIXED then...