if嵌套sum出错求助！

Question

一个村有两个人管，分开不同的组，如图，计算正确，但是结果错误！公式如下：=IF(SUM(IFERROR(SEARCH({"忠实*","*跃进*","*黎明*","*自力*","*自立*","*上游*","*上尤*","*向阳*","*友谊*","*光辉*","*香花*"},O1),))>1,"忠实彭","忠实胡")

Answer 1

=IF(OR(ISNUMBER(FIND({"忠实*","*跃进*","*黎明*","*自力*","*自立*","*上游*","*上尤*","*向阳*","*友谊*","*光辉*","*香花*"},O1))),"忠实胡","忠实彭")
试下