[已解决]求个数，请指教。用函数求多个要求的个数。附件

kilyj300

求个数，请指教。用函数求多个要求的个数，附件

最佳答案

月排行榜 / 总排行榜

xdragon

2014-1-2 00:09

1. =COUNT(IF(A1:A12=G1,FIND({"七","八","九"},B1:B12)))

复制代码

跳转到最佳答案楼层

xdragon

1. =COUNT(IF(A1:A12=G1,FIND({"七","八","九"},B1:B12)))

复制代码

笨笨四

=SUM((A1:A12=G1)*(B1:B12={"七","八","九"}))数组

=SUM(N(G1&{"七","八","九"}=A1:A12&B1:B12))数组,省一字符.

danio112

=COUNT(IF((A1:A12=G1)*FIND(B1:B12,"七八九"),1))
三键结束

tianyiyi

H1输入公式，三键结束

1. =SUM(IF(A1:A12=G1,B1:B12={"七","八","九"})*1)

复制代码

chensir

=SUMPRODUCT((A1:A12=G1)*(B1:B12={"七","八","九"}))

风林火山

=SUMPRODUCT(COUNTIFS(A1:A12,G1,B1:B12,{"七","八","九"}))
=COUNT(IF(A1:A12=G1,FIND({"七","八","九"},B1:B12)))
=SUM((A1:A12=G1)*(B1:B12={"七","八","九"}))
=SUM((A1:A12=G1)*IF(B1:B12={"七","八","九"},1))
=COUNT(0/FIND(G1&{"七","八","九"},A1:A12&B1:B12))
=SUM((A1:A12=G1)*(FIND(B1:B12,"一二三四五六七八九")>6))
=SUM(--(A1:A12&B1:B12=G1&{"七","八","九"}))
=COUNT(0/(A1:A12=G1)*FIND(B1:B12,"七八九"))

baksy

风林火山 发表于 2014-1-2 09:10
=SUMPRODUCT(COUNTIFS(A1:A12,G1,B1:B12,{"七","八","九"}))
=COUNT(IF(A1:A12=G1,FIND({"七","八","九" ...

学习！