电子表格Excel里如何计算个数

1.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=多少。

2.Excel如何计算个数

E2公式下拉：

=IF(D2="","",SUMPRODUCT((MATCH(A$2:A$9999&B$2:B$9999,A$2:A$9999&B$2:B$9999,)=ROW($1:$9998))*ROW($1:$9998)^0*(A$2:A$9999=D2)))