https://bugs.documentfoundation.org/show_bug.cgi?id=98297
m.a.riosv <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] | |rg --- Comment #1 from m.a.riosv <[email protected]> --- I have not excel, maybe SEARCH() has a different return when text it's not founded, in calc returns #VALUE!. {=COUNT(IF(ISERROR(SEARCH("brown";A1:A4));"";1))} or {=COUNT(IFERROR(SEARCH("brown";A1:A4);""))} or =SUMPRODUCT(NOT(ISERROR(SEARCH("brown";A1:A4)))) or =SUMPRODUCT(IFERROR(SEARCH("brown";A1:A4)>0;0)) or {=COUNT(IFERROR(SEARCH("brown";A1:A4)>0;""))} works for me, the interest of SUMPRODUCT() it's that is an implicit array, avoiding the need to enter the formula as array -- 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
