Question

Excel里如何计算个数

在同一列中，A、B、C、D几个数据，我想统计一共有几个A、B、C、D，请问应该用什么公式？

Answer 1

=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"),"0"),";D=",TEXT(COUNTIF(A1:A19,"D"),"0"))
输出A=多少;B=多少;C=多少;D=多少

Answer 2

Answer 3

Answer 4