https://bugs.documentfoundation.org/show_bug.cgi?id=168673
Dominik Stadler <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #203123|0 |1 is obsolete| | --- Comment #6 from Dominik Stadler <[email protected]> --- Created attachment 203125 --> https://bugs.documentfoundation.org/attachment.cgi?id=203125&action=edit Update reproducer showing which cases result in incorrect "0" results from COUNTIFS Thanks for the discussion, in the reproducer, the reproducer was slightly wrong, the updated content now comes out as Time-Formatted: 0 =COUNTIFS($A$7:$A$11;"="&$A11) 0 '=COUNTIFS($A$7:$A$12;"="&$A11) Decimal-Formatted: 0 '=COUNTIFS($A$17:$A$21;"="&$A21) 1 '=COUNTIFS($A$17:$A$22;"="&$A21) Whereas processing in Excel results in "1" for all of them. Having an "equals" fail due to precision is strange, are there two different ways of transforming the data to string before comparing? I have updated the attachment with the updated content. -- You are receiving this mail because: You are the assignee for the bug.
