統計含與不含 二格一公式 (14428)

C10:C11=SUMPRODUCT((2^ISERR(FIND("服务",MID(SUBSTITUTE(B$2:B$6,"*",REPT(" ",99)),99,99)))-ROW(A1)=0)*(A$2:A$6>=C$8)*(A$2:A$6<=E$8)*G$2:G$6)