Gg K° :
=countif(范围,值)——输出选定范围内符合该值的数据的个数例如=countif(a1:a19,"a")=countif(a1:a19,"b")=countif(a1:a19,"c")=countif(a1:a19,"d")一起输的话麻烦一点,可以参考下面的语句=concatenate("a=",text(countif(a1:a19,"a"),"0"),";b=",text(countif(a1:a19,"b"),"0"),";c=",text(countif(a1:a19,"c"),"....