怎么从Excel表中由前面的ABC用公式得出所选单元格有几个A几个B几个C

Question

例如这个表格，我要统计每一行的ABC的个数，怎么用公式统计，每一行每一行的数工作量太大了。谢谢各位精英了

Answer 1

=COUNTIF($A$1:$G$1,"A")&"A"&COUNTIF($A$1:$G$1,"B")&"B"&"A"&COUNTIF($A$1:$G$1,"C")&"C"
$A$1:$G$1为要统计的第一行数据区域

Answer 2

=COUNTIF(B11:G11,"A")&"A"&COUNTIF(B11:G11,"B")&"B"
B11:G11,是你的数据列范围

Answer 3

=COUNTIF(A1:J1000,"A")&"A"&COUNTIF(A1:J1000,"B")&"B"