=SUMPRODUCT((ISNUMBER(FIND(A6,'20111130清单'!$A$2:$A$65536))))

=SUMPRODUCT((ISNUMBER(FIND(A6,'20111130清单'!$A$2:$A$65536)))) =sumproduct(--isnumber(find("猴",a1:a10))) IF(OR(ISNUMBER(FIND("cn",A1)),ISNUMBER(FIND("com",A1))),"",A =SUMPRODUCT(ISNUMBER(FIND("A1",$C$6:$C$2536))*($G$6:$G$2536= 含数字“1” 公式是 =SUMPRODUCT(ISNUMBER(FIND("1",A1:A10))*1) excel 表格公式修改：=IF(SUMPRODUCT(ISNUMBER(FIND(G2:H2:I2,"1234567" SUMPRODUCT(ISNUMBER(FIND("主干配线电缆故障",G2:G8999))*ISNUMBER(FIND =INDEX(A:A,SMALL(IF(ISNUMBER(FIND(B$1,A$1:A$100)),ROW($1:$10 =IF(ISNUMBER(FIND("刘",G2)),"德华",IF(ISNUMBER(FIND("那",G2)),"那 =SUMPRODUCT(($A$1:$A$6 =IF(ISNUMBER(FIND("ABC",B3)),12345,67890) 这个函数里面的ISNUMBER是什么 =SUMPRODUCT(--LEFT(A1:B1,FIND("+",A1:B1)-1))&"+"&SUMPRODUCT(