用的版本是EXCEL97 可以用下面公式
在空白单元格中输入
=COUNT(IF(A1=6,1," "),IF(A3=6,1," "),IF(B2=6,1," "),IF(B3=6,1," "),IF(C1=6,1," "),IF(C2=6,1," "),IF(D3=6,1," "),IF(E1=6,1," "))
在空白单元格中输入
=SUMPRODUCT((A1=6)+(A3=6)+(B2=6)+(B3=6)+(C1=6)+(C2=6)+(D3=6)+(E1=6))
就获得A1 A3 B2 B3 C1 C2 D3 E1中数值等于6的个数
温馨提示:答案为网友推荐,仅供参考