作者：乔山办公网日期：
返回目录：excel表格制作
=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=多少
本文标签：