https://bugs.documentfoundation.org/show_bug.cgi?id=101875
--- Comment #4 from m.a.riosv <[email protected]> ---
Created attachment 127652
--> https://bugs.documentfoundation.org/attachment.cgi?id=127652&action=edit
sample with countif
(In reply to Winfried Donkers from comment #2)
> It doesn't look like a bug to me, more like unsupported use.
Looks like, FIND has my expected result with only one of the arguments as
array.
> I wouldn't know
> what FIND is supposed to do with the arguments in FIND(E2:E3;A2:C11).
Count cells that contain E2 or E3.
With the same ranges as argument =SUMPRODUCT(COUNTIF(A2:C11;".*"&E2:E3&".*"))
works fine, although needs regular expressions. I guess because the first
argument in COUNTIF is treated in a different way with array expressions.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
