Question

Excel表格中如何用计算A出现多少次?

Answer 1

假设数据在A1中,求多少个A,B1中输入

=LEN(A1)-LEN(SUBSTITUTE(A1,"A",))

多少个B,B1中输入

=LEN(A1)-LEN(SUBSTITUTE(A1,"B",))

若是一个区域内求A个数

=SUMPRODUCT(LEN(A1:B10)-LEN(SUBSTITUTE(A1:B10,"A",)))

B个数

=SUMPRODUCT(LEN(A1:B10)-LEN(SUBSTITUTE(A1:B10,"B",)))