包含三字符串的出现格數 (10144)

B7:C7=SUM(N(MMULT(1-ISERR(FIND({"ABC","DEF","XYZ"},B2:B5)),{1;1;1})=3))

E7=SUM(N(MMULT(1-ISERR(FIND({"ABC","DEF","XYZ"},T(OFFSET(B1,ROW(2:9)/2,MOD(ROW(2:9),2))))),{1;1;1})=3))

另解 E7=SUM(N(MMULT(COUNTIF(OFFSET(B1,ROW(2:9)/2,MOD(ROW(2:9),2)),"*"&TEXT({1,-1,0},"[$"&SUBSTITUTE("ABC+DEF+XYZ","+","];[$")&"]")&"*"),{1;1;1})=3))