=SUMPRODUCT(ISNUMBER(FIND({"痤疮","痘"},G2:G100))*H2:H100)=SUM(IF(ISNUMBER(FIND({"痤疮","痘"},G2:G100)),H2:H100,0))注:第二条是数组公式,Ctrl+Shift+回车结束。