D1单元格公式为
=COUNT(FIND(A1,456789)*,FIND(B1,456789),FIND(C1,456789))
或
=COUNT(FIND(A1:C1,456789)) 数组公式,按下SHIFT+CTRL+ENTER三键
如果A1至C1有空单元格时要排除,则公式为
=SUMPRODUCT(ISNUMBER(FIND(A1:C1,456789))*(A1:C1""))
D1单元格公式为
=COUNT(FIND(A1,456789)*,FIND(B1,456789),FIND(C1,456789))
或
=COUNT(FIND(A1:C1,456789)) 数组公式,按下SHIFT+CTRL+ENTER三键
如果A1至C1有空单元格时要排除,则公式为
=SUMPRODUCT(ISNUMBER(FIND(A1:C1,456789))*(A1:C1""))