https://bugs.documentfoundation.org/show_bug.cgi?id=151851
Rafael Lima <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from Rafael Lima <[email protected]> --- Created attachment 183363 --> https://bugs.documentfoundation.org/attachment.cgi?id=183363&action=edit Formula analysis Hi Mike... Using the function wizard to analyze the function I came to a similar conclusion. It seems Calc is right because an empty cell is "smaller" than a cell with text. In the sample file, cell A4 is empty hence it has 7 cells that are greater than it (which are the cells with values). The weird bit is that in Excel, testing if an empty cell is "smaller" than a cell with value also returns TRUE (as well as in Calc). But in the array function the test returns a different result, as if an empty cell is "larger" than a cell with value. Hence the problem is in the COUNTIF(range1;">"&range1) part, but IMO Excel is doing it wrong. -- You are receiving this mail because: You are the assignee for the bug.
