https://bugs.documentfoundation.org/show_bug.cgi?id=144777
--- Comment #15 from Eike Rathke <er...@redhat.com> --- Order of evaluation matters, as compareByValue() and compareByString() may deliver an exact match and only if they didn't then compareByRangeLookup() is to be tried; see also its comment at https://opengrok.libreoffice.org/xref/core/sc/source/core/data/table3.cxx?r=b60b6bfa#2941 Apart from that, COUNTIFS() doesn't do range lookups, only LOOKUP, MATCH and [HV]LOOKUP do. -- You are receiving this mail because: You are the assignee for the bug.