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

2024-11-01 21:42:49
推荐回答(1个)
回答1:

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