如果单元格内的字符不重复可以给字符加上通配符，输入以下公式=COUNTIF(B1:I11,"*a*")或者输入=COUNTIF(B1:I11,"*"&"a"&"*")
=COUNTIF(B1:i20,"*a*")
