先国 发表于 2021-12-21 07:12:00

求优化公式

=COUNTIF(C2:J2,"*A2*")+COUNTIF(C2:J2,"*C2*")+COUNTIF(C2:J2,"*B2*")+COUNTIF(C2:J2,"*G*")

烟之语 发表于 2022-2-23 10:50:04

=SUM(COUNTIF(C2:J2,{"*A2*","*C2*","*B2*","*G*"}))
页: [1]
查看完整版本: 求优化公式