怎么求和这一列？多少个H多少个T?
包含H的公式：
=SUM(--LEFT($A$1:$A$13,FIND("#",SUBSTITUTE($A$1:$A$13,B2,"#"))-1))+SUM(--IF(ISERROR(FIND("#"正乱逗,SUBSTITUTE(A$1:A$13,B2,"#",2))),0,MID(A$1:A$13,FIND("#"举卖,SUBSTITUTE(A$1:A$13,B2,"#",1))+1,FIND("#",SUBSTITUTE(A$1:A$13,B2,"#",2))-FIND("#",SUBSTITUTE(A$1:A$13,B2,"#",1))-1)))
包含T的公式：
=SUM(--IF(ISERROR(FIND("T",A1:A13)),0,MID(A1:A13,FIND("H",A1:A13)+1,FIND("陪颂T",A1:A13)-FIND("H",A1:A13)-1)))
按CTAL+SHIFT+回车 完成输入
以A1到A5举例，枣枯=SUM(COUNT(FIND("漏岩早H",A1:A5)))+SUM(COUNT(FIND("H",A1:A5,3)))，返雀然后同时按下ctrl+shift+enter。
=SUMPRODUCT(--LEFT(A1:A4,FIND("H"虚培,A1:A4)-1))&"H"&SUMPRODUCT(--MID(LEFT(A1:A4,LEN(A1:A4)-1),FIND(链兄"H",A1:A4)+1,15))&"T"棚誉袭
=SUMPRODUCT(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"亏仿培H"大搏,))
=SUMPRODUCT(LEN(A1:A10)-LEN(SUBSTITUTE(A1:A10,"T"销唯,))