https://bugs.documentfoundation.org/show_bug.cgi?id=168673
--- Comment #10 from Dominik Stadler <[email protected]> --- Thanks for the workaround of avoiding strings for equals-condition, it helps in one case. But in another place we are using "<" and as expected that has similar issues: 01:21,44 1 =COUNTIFS($A$1:$A$15;"<"&$A1) 01:28,99 4 =COUNTIFS($A$1:$A$15;"<"&$A2) 01:03,19 0 =COUNTIFS($A$1:$A$15;"<"&$A3) 01:27,99 3 =COUNTIFS($A$1:$A$15;"<"&$A4) <= Expecting „2“, but getting "3"! 01:26,47 3 =COUNTIFS($A$1:$A$15;"<"&$A5) -- You are receiving this mail because: You are the assignee for the bug.
