EXCEL如何对包含某字或某字的内容对应的值求和？

Answer 1

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